need to get the table name

[tamerelrefaie]

Dear all,

I'm building a query on a table and I want to make a new column in this query that shows the table name that I'm querying on infront of each record.

please need your help... very urgent.

[FishVal]

Dear all,

I'm building a query on a table and I want to make a new column in this query that shows the table name that I'm querying on infront of each record.

please need your help... very urgent.

????????

SELECT 'TheTable' AS [Table Name], ..... FROM TheTable;

Did you mean this?

[tamerelrefaie]

Yep, exactly

many many thanks really.

????????

SELECT 'TheTable' AS [Table Name], ..... FROM TheTable;

Did you mean this?