How to select from two tables?

[Darren884]

How would I select from two table where the category_id value is the same and number them? Thanks

[lilleman]

Hi,

You should be able to solve this using a JOIN.

Yours, Erik.

[CdeMky]

select t1.col1, t1.col2, t2.col1, t2.col2 from table1 t1, table2 t2 where t1.category_id = t2.matching_col

is that what you mean?

[Darren884]

Thanks guys all I needed was SELECT * FROM table1,table2

[Darren884]

NM