How do I extract row/column elements from multiple tables with same schema in single query
Simplest way would be to use UNION:

SELECT * FROM A
     UNION
SELECT * FROM B
     UNION
SELECT * FROM C


or use a JOIN:

SELECT *
FROM A
FULL OUTER JOIN B
ON &lt; A.name=B.name&gt;;


Read more about joins

Hope this helps.