2 Replies Latest reply: Apr 8, 2011 5:58 AM by pscorca69 RSS

    SQL Select and Left Join

      Hi,

      I need to use the statement SQL SELECT to read data from two SQL Server table left joined.

      I think to use an instruction like this:

      myTabsJoined:

      SQL SELECT T1.Attrib1, T2.Attrib2

      FROM myDB.dbo.Tab1 as T1 LEFT JOIN myDB.dbo.Tab2 as T2 on T1.KeyTab1 = T2.KeyTab2

      During the load data I haven't any syntax error, but the execution script is failed. When I have commented this statement the execution is finished successfully.

      Any helps to me, please? Thanks