Re: help with syntax of left outer join

Desmond Lee wrote: > Hi there > > I want to do a left outer join but i also have a bunch of where conditions > in my sql statment that i need. Can anyone help me out: > > SELECT title, authorName, journalName, journalPages, aname, tname, > avg(ranking) > FROM publications, area, topic, pu

Re: help with syntax of left outer join

smond >From: "Desmond Lee" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: help with syntax of left outer join >Date: Tue, 13 Aug 2002 14:34:06 -0700 > >Hi there > > >I want to do a left outer join but i also have a bunch of where conditions >in

Re: help with syntax of left outer join

AND publications.pubID = 3 GROUP BY (publications.pubID); Thanks Desmond >From: "Desmond Lee" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: help with syntax of left outer join >Date: Tue, 13 Aug 2002 14:34:06 -0700 > >Hi there > > >I wa

help with syntax of left outer join

Hi there I want to do a left outer join but i also have a bunch of where conditions in my sql statment that i need. Can anyone help me out: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications, area, topic, pubTopicInt, LEFT OUTER