get the table name from query that query 3 tables

[houssam_ballout]

Hello,I had this issue in mysql:I had made a query which select data from 3 tables, using UNION command, and its getting the results, when I want to display the results in a php page , I need to know the table that each record had been retrieved from, how can I do it?Thanks in advance

[justsomeguy]

Include the table name as a field. SELECT 'table1' AS `table`, * FROM table1 UNION SELECT 'table2' AS `table`, * FROM table2 UNION SELECT 'table3' AS `table`, * FROM table 3

[jaseervp@ymail.com]

select column_name , 'table1' as Table from table1unionselect column_name , 'table2' as Table from table2unionselect column_name , 'table3' as Table from table3 You can identify the table name form Table