Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Pls post the query if anyone knows..
I believe there is no single query that will do this.
If this was my requirement, i'd write a query that identifies all of the tables with the "master_id" column. Then, i'd use that list of tables to generate a "select count(*) from xxx where master_id = 'FT1099987' " query for each table in the list and execute that collection of queries. All of the non-zero counts would be a table containing the value you are looking for. Hopefully, master_id is a key. . .