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