[Fleur]

Dear Forum,
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

Code:

select * from table1 t1, table2 t2

i get a column not found error when trying to get the data in java using

Code:

table1id = rs.getInt("t1.Id");

rs is a resultset from the executed query and works fine when i use

Code:

select * from table1

I can't seem to find an example with google of a 2 table query

Can anyone point me in the right direction?

Cheers!

f.