+ 1

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

data from three different tables

21st Aug 2016, 6:48 PM
krishna latha
krishna latha - avatar
2 Réponses
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
21st Aug 2016, 7:19 PM
Tiger
Tiger - avatar
0
select t1.col from t1 Union select t2.col from t2 union select t3.col from t3
22nd Aug 2016, 6:56 AM
Raton Kumar
Raton Kumar - avatar