on 09-05-2020 4:13 PM
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 .
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 (...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.