how to add a column to an existing record?

[Guest]

I've made a union query and I want to add now a column to this query
Beside I want it to get the table name beside each record because these
records belongs to different tables as I said in the begining it's a union
query.

example
table1
table2
table3

union query xyz containing all data in these three tables.

I want to add a column to this query and in this column, i want it to
contain infront of each record the name of the table from which it come from.

please really need your help.

 

[Guest]

Add the following to each select statement in the union query ---
, "YourTableName" AS [TableName]

 

[Douglas J. Steele]

SELECT Field1, FIeld2, "Table1" As DataSource
FROM Table1
UNION
SELECT Field1, FIeld2, "Table2"
FROM Table2
UNION
SELECT Field1, FIeld2, "Table3"
FROM Table3

 

[Guest]

Really thanks alot Karl

Add the following to each select statement in the union query ---
, "YourTableName" AS [TableName]
--
KARL DEWEY
Build a little - Test a little

I've made a union query and I want to add now a column to this query
Beside I want it to get the table name beside each record because these
records belongs to different tables as I said in the begining it's a union
query.

example
table1
table2
table3

union query xyz containing all data in these three tables.

I want to add a column to this query and in this column, i want it to
contain infront of each record the name of the table from which it come from.

please really need your help.

 

[Guest]

Really thanks alot Douglas

SELECT Field1, FIeld2, "Table1" As DataSource
FROM Table1
UNION
SELECT Field1, FIeld2, "Table2"
FROM Table2
UNION
SELECT Field1, FIeld2, "Table3"
FROM Table3