cancel
Showing results for 
Search instead for 
Did you mean: 

Left joins are showing as right joins when query generated.

0 Kudos

I have applied Left join on tables in IDT, when query script from business layer is generated it is showing right join on the same tables where I have applied for left joins .

The data is getting matched with the database which I have checked.

As it should ideally show left join in the query itself, Could anyone please guide where i am missing something .

Accepted Solutions (0)

Answers (1)

Answers (1)

Joe_Peters
Active Contributor

The checkbox in IDT just says "outer join"; since you don't actually specify "left" or "right", are you sure you're selecting the right table?

The left/right keyword may be reversed depending on the table order. For example, if you have a join from A to B with A tagged as outer, you may see either of the following in a query:

FROM A LEFT JOIN B ON (...)

or

FROM B RIGHT JOIN A ON (...)