ms access jdbc query problem
I'm a complete java newby so please bear with me :/
I'm trying some things out with java and ms access.
I manage to connect to my db, and get data from a table. However I'm running into problems when I need data from 2 related tables.
The following query works fine in access
i get a column not found error when trying to get the data in java using
select * from table1 t1, table2 t2
rs is a resultset from the executed query and works fine when i use
table1id = rs.getInt("t1.Id");
I can't seem to find an example with google of a 2 table query
select * from table1
Can anyone point me in the right direction?