troubleshooting Question

MS-SQL join queries based on common (not exact) results

Avatar of rlarian
rlarianFlag for United States of America asked on
Microsoft SQL Server
14 Comments1 Solution245 ViewsLast Modified:
Query1 returns names and skills, Query2 returns jobs and required skills

Query1            
Name1      skill1      
Name2      skill1
Name2      skill2
Name3      skill2

Query2
Job1      skill1
Job2      skill1
Job2      skill2
Job3      skill2

The desired final result would be a list of names and the jobs
Name1      Job1
Name2      Job1
Name2      Job2
Name2      Job3
Name3      Job3
ASKER CERTIFIED SOLUTION
Dale Burrell
Director

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 14 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 14 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