Posted by Shelly on 11/11/07 01:29

I know [Jerry and co.] that this is off-topic, but the sql group that I
could find online doesn't have much traffic, so here goes.

I cam across this code:

SELECT AnnoID, AnnoTitle,
(SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
mEVENTS.EventID)
as AnnoLink,
date_format(AnnoDate,'%M %D %Y') as date
FROM tblANNOUNCE
ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle

I am having trouble reading this. Is this the same as:

SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
date_format(AnnoDate,'%M %D %Y') as date
FROM tblANNOUNCE AS a, mEVENTS AS e
WHERE a.AnnoLink = e,EventID
ORDER BY date DESC, AnnoLink, AnnoTitle


In other words, do they do exactly the same thing? I can't get the former
to run on the current version of MySQL. Apparantly (I was told) it ran on a
later version of MySQL.

--
Shelly

• Next in forum: Re: Using a class to handle the output of another class
• Prev in forum: Re: Is there any function in php that will match a word exactly and if it finds it, it returns true.
• Thread view: OT - an SQL question

[Reply to this message]