Postgres Pro
Downloads
Home   >   mailing lists

How can we match a condition among 2 diff. tables? - Mailing list pgsql-sql

From bhuvansql@yahoo.com
Subject How can we match a condition among 2 diff. tables?
Date
Msg-id 200107130611.LAA24039@Larry.bks
Whole thread Raw
Responses Re: How can we match a condition among 2 diff. tables?  (Peter Eisentraut <peter_e@gmx.net>)
Re: How can we match a condition among 2 diff. tables?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
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
NONEof the salesorders. ie.. i wish to select the records of table 'employee' whose 'emp_id' are not there in table
'salesorder'.Ineed to accompolish in a single query!Thankx in advance.Regards,Bhuvaneswar.

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referencing a view?
Next
From: "Grigoriy G. Vovk"
Date:
Subject: Re: Referencing a view?