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
Printable View
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
select a.tbl1a, a.tbl1b, b.tbl2a, b.tbl2b, b.tbl2c from table1 a, table2 b where a.tbl1a=b.tbl2a
I think I got it.
Thanks!