[AccessD] Table name in query

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Oct 13 08:19:41 CDT 2005


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.

 




More information about the AccessD mailing list