I have Join query that find data from three table so how can I know the data is founded from which table
select text from table1 where title ='Vishal' union all select text from table2 where title ='Vishal' union all select text from table3 where title ='Vishal'
This query give me my desired output but I want to know
title match from which table and I want to get the Table name
Aucun commentaire:
Enregistrer un commentaire