web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Query - outer join

(0) ShareShare
ReportReport
Posted on by

Hello,

I am using the query in the AOT.

Can I join two tables in the query as "left outer join" (that if there are no data on the inner table - it should appear as null)?

Thanks :)

*This post is locked for comments

I have the same question (0)
  • Amir Nazim Profile Picture
    5,994 on at

    this is not clear, the task you looking for have no data on inner table and you want parent table record to be null as well, that means parrent and child does not have any information so do you needed empty information ?

    or you looking inner where you can have from parents when you have related info in child.

  • Community Member Profile Picture
    on at

    Little confuse ... Maybe I didn't clarified myself ...

    It's view (not a query).

    What all I need is to use the view object in AOT, and do the simmiliar thing as "outer join" in Microsoft-Sql-Server. (Join two tables in outer join link).

    How can I do that?

    Thanks :)

  • Suggested answer
    Amir Nazim Profile Picture
    5,994 on at

    create the AOT query, there you can specify the join mode to outer join. then drag the query to view.

  • Community Member Profile Picture
    on at

    How and where ? - I see I cannot drag query to the view (I cannot copy to datasource, or any node on the View).

    Thanks :)

  • Amir Nazim Profile Picture
    5,994 on at

    it is dragable to the metadata node of view.

  • Community Member Profile Picture
    on at

    Well, that I defenitly have tried, but with no success (I cannot drag to metadata, or any of the nodes a query object).

    Thanks :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans