|
|
Posted by Darko on 11/12/07 03:09
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
Navigation:
[Reply to this message]
|