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 HAA24842 for postgres-redist; Mon, 6 Mar 1995 07:30:13 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199503061530.HAA24842@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 sunic.sunet.se (sunic.sunet.se [192.36.125.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id HAA24832 for ; Mon, 6 Mar 1995 07:30:05 -0800 Received: from cocos.fuw.edu.pl by sunic.sunet.se (8.6.8/2.03) id QAA14531; Mon, 6 Mar 1995 16:29:41 +0100 Received: from ccfs1.fuw.edu.pl by cocos.fuw.edu.pl (4.1/SMI-4.1) id AA19598; Mon, 6 Mar 95 16:29:29 +0100 Received: by ccfs1.fuw.edu.pl (4.1/SMI-4.1) id AA25966; Mon, 6 Mar 95 16:29:26 +0100 Date: Mon, 6 Mar 1995 16:29:25 +0100 (MET) From: Kacper Nowicki X-Sender: kacper@ccfs1 To: Postgres Mailing List Subject: Retrieve query Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Mon, 06 Mar 95 07:30:13 -0800 Resent-XMts: smtp Hi, I have two classes: one with info about institutions and second with their phone numbers (and with institution id). How should I write query which returns institution name and phone number ? I need name even if there is no phone number for it. Simple : retrieve (i.name, ph.number) where i.id=ph.id returns only those instances from i which has matching entry in ph. Thanks in advance, Kacper ------------------------------------------------------------------------ Kacper Nowicki e-mail: Kacper.Nowicki@fuw.edu.pl Warsaw University ================================= Physics Department Computer Center Hoza 69, 00-681 Warszawa, Poland fax: (+48)(22)294309 ============================================================================== 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/