SQL Select and Left Join

[#1]

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

[deepakk]

hi,

try the debug option, it might show u the exact error.

Is there any code which follows after this query.

If yes then you might have forgoten to add a semicolon at the end of the script.

[#3]

In the SQL SELECT there is a ISNULL(T1.myField1,0) as myF1 that seems doesn't function. After some loads, the script seems to function with success. Sorry for this post. The issue is solved.

Thanks