SQL Query from 2 tables

[TimC]

I would like to use a SQL Query to get fields from two different tables in the same database. Say table1 and table2 with fields tbl1a, tbl1b, tbl2a, tbl2b and tbl2c. Can I do this and if so how?

Thanks

[JHausmann]

select a.tbl1a, a.tbl1b, b.tbl2a, b.tbl2b, b.tbl2c from table1 a, table2 b where a.tbl1a=b.tbl2a

[TimC]

I think I got it.

Thanks!