Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

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