Re: [SQL] How can we match a condition among 2 diff. tables?

[Andre Schnabel]

Hi,

if you translate your (english) idea striktly to SQL, you'll make it ;-)
 
>  Now, i need to get the details of all employees who did 
>  receive NONE of the salesorders. ie.. i wish to select the 
>  records of table 'employee' whose 'emp_id' are not 
>  there in table 'salesorder'.

SELECT * FROM employee
WHERE emp_id NOT IN (
    SELECT emp_id FROM salesorder
);




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster