troubleshooting Question

Is there a way to get non Matches from two tables using LINQ

Avatar of EAK31640GW
EAK31640GW asked on
Microsoft SQL ServerC#
7 Comments1 Solution291 ViewsLast Modified:
Is there a way to only return/ include non matches? Excluding the rows that match

Table A:
Name         Number       Title
Joe            1                  Mr
Jim             2                  Dr
Jack           3                  Mr
Mike           4                 Dr

Table B:
Name         Number       Title
Mike           4                 Mr
Moe           5                 Dr
Max           6                  Mr
Jim             2                  Dr
Jack           3                  Mr


??? Query:
Name         Number       Title
Joe            1                  Mr
Mike           4                 Dr
Mike           4                 Mr
Moe           5                 Dr
Max           6                  Mr
ASKER CERTIFIED SOLUTION
veenaravind

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros