php - See which table a result is in

Solution:

To complete this query, useunion all:

select
    'Table1' as TableName,
    *
from
    Table1
union all
select
    'Table2',
     *
from
    Table2
union all
select
    'Table3',
    *
from
    Table3
Copy code

...and so on

For better database design, you would want to either have one table with all the rows in it, and a designated Status table where you can link a StatusID column to that says what status that given row is in. A table for each stage in a process is a poor design and will only lead to massive headaches down the road.

Solution:

If you can't reorganize the tables so that you have just one with all rows and a marker for where in the process they are, I would go for aUNION-approach. Ie:

SELECT 'Data from Table 1', t1.field1, ...
  FROM Table1 t1
 UNION
SELECT 'Data from Table 2', t2.field1, ...
  FROM Table2 t2
 UNION
 (Table3, 4, 5 and 6 in the same manner)
....
Copy code

That way you can see where the data is originating from and you get all 6 at once. Just remember that you have to have the exact same field list in all parts of theUNION.

Solution:

You could create a code generator that generates SQL statements to query the 6 tables. The generator would create a UNION of 6 selects and add a "table" column to each select with a constant value equal to the name of the table queried. That would make writing the statements easy, though I wouldn't say that writing the generator would be.