From: bhuvansql@yahoo.com
To: pgsql-sql@postgresql.org
Subject: How can we match a condition among 2 diff. tables?
Date: Fri, 13 Jul 2001 11:41:10 +0530
Message-ID: <200107130611.LAA24039@Larry.bks> (raw)
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!
Thankx in advance.
Regards,
Bhuvaneswar.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bhuvansql@yahoo.com
Subject: Re: How can we match a condition among 2 diff. tables?
In-Reply-To: <200107130611.LAA24039@Larry.bks>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox