topic SQL Select and Left Join in QlikView

SQL Select and Left Join

Fri, 08 Apr 2011 09:37:46 GMT

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

SQL Select and Left Join

deepakk — Fri, 08 Apr 2011 09:41:45 GMT

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.

SQL Select and Left Join

Fri, 08 Apr 2011 09:58:07 GMT

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