How can we use multiple join query when we have to use it with different table.In using multiple join we write the joining condition taking first table in the sequence as refrence. But if in the joining conditions we have to use different tables then how to write such query. Can we write the query like this : Eg. select t1.firstname,t2.lastname,t3.address,t4.country from table1 t1 inner join table2 t2 on t1.row_id=t2.row_id inner join table3 t3 on t2.row_id=t3.row_id
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.
PLEASE READ THE FULL DISCLAIMER AND LEGAL TERMS BY