Question: sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 ..
this is for single table :
query ="SELECT name , age , pwd , phone , address FROM t1 order by name";
this is for 2 tables :
query ="SELECT t.name , t.age , tt.pwd , tt.phone , t.address FROM t1 t t2 tt where t.age=tt.age order by name";
i want for 12 tables :
i want to fetch name age pwd phone address from 12 tables .... query pl..z