SELECT distinct A.col1, A.col2, B.col3, B.col4, C.col5, Left(C.col5, 8) AS GLAccount, D.col6, E.col7, D.col8 as LineItemTotal FROM dbo.TABLE1 A LEFT OUTER JOIN dbo.TABLE2 B ON A.col1=B.col1 LEFT OUTER JOIN dbo.TABLE3 C ON A.col1 = C.col1 LEFT OUTER JOIN TABLE4 D ON B.col2 = D.col2 LEFT OUTER JOIN TABLE5 E ON D.col3=E.col3 ORDER BY A.col2 ASC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)