You’re offline. This is a read only version of the page.
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 (
8,826
while select MergedCustomer
notexists join Customer
where Customer.CustomerId == MergedCustomer.CustomerId
&&(Customer.Age < 40
|| Customer.Age > 50)
{
}
