Select on multiple tables based on "IDs" from the first table

[siilexx]

Hello,

I'm trying to build a query that will search information on a few tables at once, in an Access database.

I must SELECT all records from a "Table1", then a few columns from "Table2" using a "WHERE Table2.ID=Table1.IDClient".

What's the best way of working (Multiple select, JOIN or else) ?

Thank you

[Rabbit]

Use a join.

[siilexx]

The following query is working:
myQuery = "SELECT Bail.*, Client.ID, Client.NoClient, Client.Label, Client.Adresse, Client.CP, Client.Commune, ClientBail.* FROM ((Bail LEFT OUTER JOIN Client ON Bail.IDClient=Client.ID) LEFT OUTER JOIN ClientBail ON Bail.IDClientBail=ClientBail.ID) ";

Thank you