inner join mysql tables

[omega2639]

Ok here it is. i have two tables: products and product_sizesso basically my product table has id(primary key),name(product name)and size_id(foreign key from product_sizes)my product_sizes table has predetermined values:\[code\]size_id name------------------1 1x12 2x23 3x3\[/code\]and here i have a working code displaying the product tables(in html using while code):\[code\]id name size_id-----------------------------1 product 1 12 product 2 23 product 3 1\[/code\]my problem is that i want to display(in html) the size name rather than its size_id, something similar to these example:\[code\]id name size_id-----------------------------1 product 1 1x12 product 2 2x23 product 3 1x1\[/code\]can someone teach me how to do this?.. i need it urgently for my final project. thank you. sorry for my explanation im not good in english.