Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id WAA01450 for postgres-redist; Thu, 2 Nov 1995 22:15:03 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199511030615.WAA01450@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from staff.cs.su.OZ.AU (staff.cs.su.OZ.AU [129.78.8.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id WAA01536 for ; Thu, 2 Nov 1995 22:15:01 -0800 Received: from stone.oz.au by staff.cs.su.OZ.AU (mail from daryl for postgres@postgres.berkeley.edu) with MHSnet (insertion MHSnet site: odtdev.rnd.stone.oz.au); Fri, 03 Nov 1995 17:14:30 +1100 From: daryl@stone.oz.au (Daryl Sayers) X-Mailer: SCO System V Mail (version 3.2) To: postgres@postgres.Berkeley.EDU Date: Fri, 3 Nov 95 12:23:18 AEST Message-ID: <9511031223.aa22499@odtdev.stone.oz.au> Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 02 Nov 95 22:15:03 -0800 Resent-XMts: smtp Newsgroups: stone.mlist.postgres Path: daryl From: daryl@stone.oz.au (Daryl Sayers) Subject: Simple retrieve question Organization: Stone Microsystems, NSW, Australia Date: Fri, 3 Nov 1995 02:23:12 GMT Message-ID: X-Newsreader: NN version 6.5.0 #3 O.K. call me lame, but I can't figure it out..... I have 2 classes, One for Company info and 1 for Contacts. For every Contact record there is an id that points to the Company it belongs to. My questions how can I retrieve all the Companys that do not have a Contact record. -- Daryl Sayers Ph: (02) 417 3788 Stone Group Asia Pacific Fax: (02) 417 3741 Unit 20, 380 Eastern Valley Way Email: daryl@stone.oz.au Roseville, 2069 NSW Australia WWW: http://sydney.DIALix.com/~stone ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/