Posted by Shelly on 11/11/07 23:52

Jerry Stuckle wrote:
> Shelly wrote:
>> 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.
>>
>
> Yes, it's off topic. And your inability to find comp.databases.mysql
> does not excuse you posting it here.

I do not have access to comp.database.mysql on my news server and, frankly
Jerry, I couldn't care less about your opinion here.

--
Shelly

[Back to original message]