From: Sarfaraz Patel <s.patel@ctc.ucl.ac.uk>
To: 'pgsql-sql@postgreSQL.org' <pgsql-sql@postgreSQL.org>
Subject: outer join syntax
Date: Fri, 31 Mar 2000 11:56:45 +0100
Message-ID: <B7923E21D75AD311A4FB009027AA447C0C3651@CTCMAIL> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: s.patel@ctc.ucl.ac.uk
Subject: Re: outer join syntax
In-Reply-To: <B7923E21D75AD311A4FB009027AA447C0C3651@CTCMAIL>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox