Member Avatar for aseel_1

Salam all :)

anyone can help me to understand this query in venn diagram

SELECT e.id, 
       e.name 
FROM   emp e 
       INNER JOIN deptid D_X 
               ON e.empid = d_x.empid 
                  AND deptid = 'X' 
       LEFT JOIN deptid D_Y 
              ON e.empid = d_Y.empid 
                 AND deptid = 'Y'
WHERE  d_Y.empid IS NULL
  • 2 Contributors
  • 1 Reply
  • 80 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol 
SELECT e.id, 
       e.name 
FROM   emp e 
       INNER JOIN deptid D_X 
               ON e.empid = d_x.empid 
                  AND deptid = 'X' 
       LEFT JOIN deptid D_Y 
              ON e.empid = d_Y.empid 
                 AND deptid = 'Y'
WHERE  d_Y.empid IS NULL

I'm assuming that you're retrieving employee details from departments where employee is member of deptid X but not Y

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.