I have a single select query with multiple table joins in it.
I want to retrieve the Most Recent records from one of the table among the tables in multiple joins.
(select t1.col1, t2.col2 , t3.col3, t4.col4, t4.Add_Date,t5.col5,
from dbo.table1 t1
left outer join dbo.table2 t2 on t1.col1=t2.col2
left outer join
(select col3 from dbo.table3 where condition1="expr") as t3
left outer join dbo.table4 t4 on t1.col1=t4.col4 order by t4.Add_Date
left outer join dbo.table5 t5 on t1.col1=t5.col5 )
Problem is that, I am not able to use the "Order by" for a particular table.
View Complete Post