Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with a SQL statement please...

Help with a SQL statement please...

From: harry <a_at_abc.com>
Date: Fri, 14 Jul 2006 14:52:26 GMT
Message-ID: <KcOtg.101365$wl.27646@text.news.blueyonder.co.uk> 





I have 2 tables, CUSTOMER & CONTACT - CUSTOMER has a primary key field
called ID, CONTACT has a foreign key to it called CUST_ID



I want to select all rows from CUSTOMER that don't have any CONTACT rows -
i.e. customers with no contacts!



any ideas?



thanks



harry
Received on Fri Jul 14 2006 - 09:52:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US