6
I want to issue the following query with Left outer join, but I can't do it with the current specification, so I want it to be possible.

Select *
from "Sales Header" as H
left outer join "Sales Line" as L
on H."Document Type" = L."Document Type"
and H."No." = L."Document No."
and L.Type = '2'. // Item

In the current specification, only the following SQL can be issued, and this difference is very large under complicated conditions.

Select *
from "Sales Header" as H
left outer join "Sales Line" as L
on H."Document Type" = L."Document Type"
and H."No." = L."Document No."
where L.Type = '2'. // Item
Category: Development
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team