web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Union 2 table avoid du...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Union 2 table avoid dupplicate item except item match condition

(0) Share

Report

Report

Posted on by Vu Tran

Hi,

I have 2 table Customer and MergedCustomer, because of business, I have to union those tables on there conditions:

MergedCustomer.CustId not in Customer.CustId.

OR (MergedCustomer.CustId in Customer.CustId And Customer.Age >= 40 And Customer.Age <= 50.

Is there anyway to write a Query to do this?

I try to google it but there is no suitable solution.

So thank you really much if you help me.

By the way, thank for reading my poor English post, it's not my native English so probably it seems silly sometime.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!
while select MergedCustomer notexists join Customer where Customer.CustomerId == MergedCustomer.CustomerId &&(Customer.Age < 40 || Customer.Age > 50) { }

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 658

#2

André Arnaud de Cal... 495 Super User 2026 Season 1

#3

Syed Haris Shah 315 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans