i have inner joined the t1 and t2 table and result is as per logict1 Joins t2 & result but when i join table2 and table3, order of row output is not as per earlier table join logic.t2 join t3 & expected and actual result.
without using Order by, how can i get expected result. why record is not ordered in t2 & t3 compared with t1 & t2 logic?
t2 join t3 & expected and actual result
New contributor
Dhana Sekaran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.