outer join syntax

From: Sarfaraz Patel <s(dot)patel(at)ctc(dot)ucl(dot)ac(dot)uk>
To: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: outer join syntax
Date: 2000-03-31 10:56:45
Message-ID: B7923E21D75AD311A4FB009027AA447C0C3651@CTCMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander Stetsenko 2000-03-31 12:23:34 Novice trouble with plpgsql
Previous Message Wilson Fletcher 2000-03-31 05:16:29 RE: Loading values in from postgreSQL database into a combo box using PHP