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	July 13, 2001 05:14:50
Msg-id	200107130611.LAA24039@Larry.bks Whole thread Raw
Responses	Re: How can we match a condition among 2 diff. tables? Re: How can we match a condition among 2 diff. tables?
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:

From: Stephan Szabo
Date: 12 July 2001, 22:04:37
Subject: Re: Referencing a view?

From: "Grigoriy G. Vovk"
Date: 13 July 2001, 07:10:40
Subject: Re: Referencing a view?

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

Previous

Next