Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id C1E6E475999 for ; Wed, 5 Jun 2002 22:11:14 -0400 (EDT) Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph [202.90.128.8]) by postgresql.org (Postfix) with ESMTP id A78C2475956 for ; Wed, 5 Jun 2002 22:11:12 -0400 (EDT) Received: from asti.dost.gov.ph (askr.asti.dost.gov.ph [10.10.5.36]) by kitana.asti.dost.gov.ph (Postfix) with ESMTP id 173EE2585A for ; Thu, 6 Jun 2002 10:08:45 +0800 (PHT) Message-ID: <3CFF78C6.82AEDF9A@asti.dost.gov.ph> Date: Thu, 06 Jun 2002 10:59:18 -0400 From: Joseph Syjuco Organization: Advanced Science and Technology Institute X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.8-26mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: simple select statement inquiry Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/45 X-Sequence-Number: 8010 table1 empno varchar(9) not null peer varchar(9) not null references table2(empno) superior varchar(9) not null references table2(empno) table2 empno varchar(9) firstname varchar(20) lastname varchar(20) what i want to do is get all entries in table 1 and transform peer and superior fields (which contains empno) into their respective firstname + lastname in one query desired output empno peer superior 1000 John Smith Henry Dunst 2000 Juan dela Cruz Pepe Smith TIA joseph