How can we match a condition among 2 diff. tables?

Поиск
Список
Период
Сортировка
От bhuvansql@yahoo.com
Тема How can we match a condition among 2 diff. tables?
Дата
Msg-id 200107130611.LAA24039@Larry.bks
обсуждение исходный текст
Ответы 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>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Referencing a view?
Следующее
От: "Grigoriy G. Vovk"
Дата:
Сообщение: Re: Referencing a view?