Guest Andrew Buchan Posted September 7, 2009 Share Posted September 7, 2009 I have an Application which queries multiple tables in a SQL Server 2005 Database.For example I have 3 tables, for simplicity sake lets say the tables are called t1, t2 and t3And in those tables I am checking columns for a given value, lets say the columns are called c1 and c2.So, I want to return an extra column/field that states the name of the column which contains the given search value.Is this possible in a query? Link to comment Share on other sites More sharing options...
PravinBhat Posted October 12, 2009 Share Posted October 12, 2009 I dont think that there is a way to do so Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.