Whoops... forgot the "on" in the join stament.
I change it to include the on, but still no luck. Does anyone have any idea?
SELECT title, authorName, journalName, journalPages, aname, tname,
avg(ranking)
FROM publications LEFT OUTER JOIN ranking ON
(publications.pubID = ranking.pubID), area, topic, pubTopicInt,
WHERE publications.areaID = area.areaID
AND
publications.pubID = pubTopicInt.pubID
AND
topic.topicID = pubTopicInt.topicID
AND
publications.pubID = ranking.pubID
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 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 JOIN ranking publications.pubID = ranking.pubID
> WHERE publications.areaID = area.areaID
> AND
> publications.pubID = pubTopicInt.pubID
> AND
> topic.topicID = pubTopicInt.topicID
> AND
> publications.pubID = ranking.pubID
> AND
> publications.pubID = 3
> GROUP BY (publications.pubID);
>
>I look at the mysql documentation, but i couldn't really understand their
>examples when they had additional where cluases.
>
>THanks
>
>
>Desmond
>
>_________________________________________________________________
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
