|
|
Posted by Jerry Stuckle on 11/12/07 00:00
Shelly wrote:
> 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,
You can continue to be an asshole - or you can ask your ISP to carry
comp.databases.mysql. Or you can access it via google groups.
But as long as you're posting off-topic subjects here because you're to
f'ing lazy to access the correct group. I will call you on it.
Get it through your thick skull. This is NOT your personal help group.
This is one for PHP.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|