+ 1
how to fetch data from three different tables for a particular column at a time .??
data from three different tables
2 ответов
0
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
0
select t1.col from t1
Union
select t2.col from t2
union
select t3.col from t3