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