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
);