You’re offline. This is a read only version of the page.
Announcements
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.
Share
Report
All responses (
Answers (
while select MergedCustomer
notexists join Customer
where Customer.CustomerId == MergedCustomer.CustomerId
&&(Customer.Age < 40
|| Customer.Age > 50)
{
}
#1
André Arnaud de Cal...
294,118
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
