Inner Join

[alehawk]

Hi!!!
I got a DB, table1 has categoryid & product, table2 has ID & txtcategory.
I want to show every product in the DB and it relatex category. My sqlstm is
SELECT * FROM TABLE1
But I know that with inner join I can display the txtcategory by reading the categoryid from table1. I dont know how to use the inner join, can anyone explain me how it works or can send me a link to a tutorial that shows how to use it?
Tnx!!!

 

[amorous]

Select categoryid, product,txtcategory from table1
inner join table2 ON categoryid.table1=Id.table2

-VJ

 

[vongrunt]

faq183-4785

 

[alehawk]

Tnx both!!