Loading

Select from more than one Table at once

NeCroFire

I want to select from more than one table in one statement, from an Access Database.

Can one do this?
What would the statement look like?

Or do I need to run some form of a loop and change the TableName each time? (I don't like this way very much...)

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sourabh Sharma18y ago

Either use JOIN on multiple table

Select field1,field2,......FROM TABLE1 INNER JOIN TABLE2 ON

table1.field1(PK)=table2.field1(FK) and so on

Or u can use select statement if u dnt have any coniditon

· SELECT * FROM

· (SELECT * FROM Customers ORDER BY Id ASC) AS Table1

ORDER BY Id DESC