Select from more than one Table at once

Question

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

Sourabh Sharma · Answer

Either use JOIN on multiple table Select field1field2......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