Hello, I wonder if it is possible to select the name of a table that a record came from, here is the scenario:<BR><BR>I have 4 tables, and I want to run a query like:<BR>SELECT Field1, TableName From table1, table2, table3, table4 where memberID = 4637<BR><BR>Then display the results like:<BR><BR>Table1:<BR>Field1<BR>Field1<BR><BR>Ta ble2:<BR>Field1<BR>Field1<BR><BR>Table3:<BR>Field1 <BR><BR>Table4:<BR>Filed1<BR><BR>???<BR><BR>Than ks in advance!