Something like?
select employee.* from employee where
not exists (select * from salesorder where
salesorder.emp_id=employee.emp_id);
On Fri, 13 Jul 2001 bhuvansql(at)yahoo(dot)com wrote:
>
>
> Hi,
>
> Consider the below...
>
> table 'employee' with unique 'emp_id',
> table 'salesorder' with 'emp_id' and unique 'sales_id'
>
> Remember, both tables include some more different fields.
>
> 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'.
>
> I need to accompolish in a single query!