Hi Guys ! I don't really know w

[funyman]

Hi Guys !

I don't really know where to post my question both since I'm developing in Java......
I have DB Access using (for now) Microsoft Access in my Java application... connection and that are fine my problem is to retreive the info on a relationship table. can you give me a SQL queries sample

let say I have Table 1 with colum first as primary key and linked to table 2 having column second. How can I make a queries that will collect value from Column first and second in one call?

Thanks for the help ... and please if you think I'm really not it the right forum let me know where to go !
Thanks

 

[davidrv]

select table2.column2,... from table1, table2
where table1.column1 = table2.column1
and...

 

[funyman]

Thank youuu !

I knew it was something easy !