Posted by Jerry Stuckle on 11/12/07 03:43

Darko wrote:
> On Nov 12, 1:00 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> 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.
>> jstuck...@attglobal.net
>> ==================
>
> Sorry for being direct, but while not rarely you post messages in form
> of:
> ".... asshole ..."
> ?
>
> Regards
>
>

Hey - I call them like I see them.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]