outer join syntax - Mailing list pgsql-sql

From Sarfaraz Patel
Subject outer join syntax
Date
Msg-id B7923E21D75AD311A4FB009027AA447C0C3651@CTCMAIL
Whole thread Raw
Responses Re: outer join syntax
List 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


pgsql-sql by date:

Previous
From: Wilson Fletcher
Date:
Subject: RE: Loading values in from postgreSQL database into a combo box using PHP
Next
From: Alexander Stetsenko
Date:
Subject: Novice trouble with plpgsql