Reply to Re: OT - an SQL question

Your name:

Reply:


Posted by Steve on 11/12/07 14:16

"Darko" <darko.maksimovic@gmail.com> wrote in message
news:1194836950.029815.172190@22g2000hsm.googlegroups.com...
> 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 ..."

'not rarely' is about right. i was labeled 'asshole', 'stupid', 'lousy', and
'senseless' by jerry last week. apparently, he doesn't like being disagreed
with...especially if you back your argument(s) while he fails to be able to.
:)

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация