Received: from ctcmail.ctc.ucl.ac.uk (ctcmail.ctc.ucl.ac.uk [128.40.245.150]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA60728 for ; Fri, 31 Mar 2000 05:52:46 -0500 (EST) (envelope-from s.patel@ctc.ucl.ac.uk) Received: by CTCMAIL with Internet Mail Service (5.5.2448.0) id ; Fri, 31 Mar 2000 11:56:56 +0100 Message-ID: From: Sarfaraz Patel To: "'pgsql-sql@postgreSQL.org'" Subject: outer join syntax Date: Fri, 31 Mar 2000 11:56:45 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200003/13 HI, Regarding the syntax for outer join.....i try using this for my query... select ran, "pr", "followup" from view_pr, view_followup where ran.trialno *=* view_pr.trialno and ran.trialno *=* view_followup.trialno; I hope its right..but gives the error missing expression pointing at the *=* sign... help would be appreciated thanx saf