joins in sql transformation in bods

[Former Member]

Hi

I have a complex query with multiple joins, I am not able to do it in any other transformation.

When I am trying left outer join in sql transformation I am getting error.

I am not able to find the syntax for that any where,

Here is what I have wrote:

select table1.ROW_ID,table2.NAME

     from table1 leftouterjoin table2 on

     table1.column_name = table2.column_name

but I am getting syntax error, what is the exact syntax of sql transform please help

Regards

Karishma

[KayKa]

Hi Karishma,
do you use spaces in "left outer join" ?
The rest of the coding seems correct.

regards
Kay