how to fetch data from three different tables for a particular column at a time .??

Question

data from three different tables

Answer 1

SELECT t1.name, t2.name,t3.name FROM
t1 INNER JOIN t2 ON t1.id=t2.id INNER JOIN t3 ON t2.id=t3.id
WHERE t1.id=5

Answer 2

select t1.col from t1
Union
select t2.col from t2
union
select t3.col from t3