How to map columns to there table

[pmane-uptycs]

If i have a sql like this :

SELECT name FROM kva_speculative_info WHERE name LIKE 'a%'
UNION SELECT name FROM ie_extensions WHERE name LIKE 'a%' ;

How to map columns to respective tables

[georgesittas]

Take a look at this older discussion thread. Let me know if you encounter any issues or something's unclear, and I'll be happy to help.