[AccessD] Table name in query

Is there a way to return the name of the table a field in a query in
returned from? 

Something like

SELECT tablename of tableone.field1, tableone.field1 

from tableone 

where tableone.field2 = tabletwo.field2

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.