OT - an SQL question

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.

--
Shelly

Re: OT - an SQL question

On Nov 10, 8:29 pm, "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.
>

They should be the same. I generally see the first type of query when
someone doesn't really understand joins. It also typically results in
horrible performance.

What do you mean when you say you "can't get the former to run?" Do
you get an error?

Re: OT - an SQL question

ZeldorBlat wrote:
> On Nov 10, 8:29 pm, "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.
>>
>
> They should be the same. I generally see the first type of query when
> someone doesn't really understand joins. It also typically results in
> horrible performance.

Hmmm. I learned the second type about 25 years ago and is always how I do
those joins. My client's customer changed servers and the new server has an
older version of MySQL. They ran into problems with many queries. I
started looking at the code, and the first one I came accross was the first
version (longer in length, I stripped it down for the posting). I copied
that code and went to phpmyadmin and did a sql query. It barfed and
complained mightily on the sub-select. I tried to analyze what the original
coder was intending to do, and came up with the second one (I wrote that
one). That one worked. I just wanted some verification from other
professionals that I was reading the original correctly in what the coder
was intending to do -- before I proceeded on my merry way modifying code in
some twenty modules.

--
Shelly

Re: OT - an SQL question

What the original coder was do was subselects. This is supported on MySQL
4.1 and above. The version on the server that it is being moved to is
4.0.27, so that is why it didn't work. For the one I posted, there was a
simple way of recoding it. As I progressed futher into it, there were more
complex cases that required a subselect. Otherwise, it required multiple,
separate queries. For example:

select
ID,
(select ArtistName from mARTISTS where tblMain.MnArtist1 =
mARTISTS.ArtistID) as Artist1,
MnArtist1Desc,
(select ArtistName from mARTISTS where tblMain.MnArtist2 =
mARTISTS.ArtistID) as Artist2,
MnArtist2Desc
from tblMain
where MnEvent = '22'
ORDER BY MnOrder

--
Shelly

Re: OT - an SQL question

Greetings, Shelly.
In reply to Your message dated Sunday, November 11, 2007, 04:29:29,

> 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.


Try this (if I understand it correctly)

SELECT
a.AnnoID, a.AnnoTitle, e.EventTitle as AnnoLink, date_format(a.AnnoDate,'%M %D %Y') as date
FROM tblANNOUNCE a LEFT (or INNER) JOIN mEVENTS e ON a.AnnoLink = e.EventID
ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle

Choose LEFT or INNER depends on database structure.


--
Sincerely Yours, AnrDaemon

Re: OT - an SQL question

On Sun, 11 Nov 2007 04:37:02 +0100, Shelly =

wrote:

> What the original coder was do was subselects. This is supported on =

> MySQL
> 4.1 and above. The version on the server that it is being moved to is=

> 4.0.27, so that is why it didn't work. For the one I posted, there wa=
s a
> simple way of recoding it. As I progressed futher into it, there were=
=

> more
> complex cases that required a subselect. Otherwise, it required =

> multiple,
> separate queries. For example:
>
> select
> ID,
> (select ArtistName from mARTISTS where tblMain.MnArtist1 =3D
> mARTISTS.ArtistID) as Artist1,
> MnArtist1Desc,
> (select ArtistName from mARTISTS where tblMain.MnArtist2 =3D
> mARTISTS.ArtistID) as Artist2,
> MnArtist2Desc
> from tblMain
> where MnEvent =3D '22'
> ORDER BY MnOrder

And that's why you should post in a MySQL group. This query still does n=
ot =

require a subselect.

SELECT m.ID, a1.ArtistName, m.MnArtist1Desc, a2.ArtistName, =

m.MnArtist2Desc =

FROM tblMain m
LEFT JOIN mARTISTS a1
ON a1.ArtistId =3D m.MnArtist1
LEFT JOIN mARTISTS a2
ON a2.ArtistId =3D m.MnArtist2
WHERE m.MnEvent =3D '22';
ORDER BY m.MnOrder

.... allthough this seems limited to 2 Artists. Fine if the business logi=
c =

requires there are always 2, if not, the relation should be moved to a =

relational tabel containing an tblMain ID and an ArtistId, so you can ha=
ve =

any number of artists from 0 to virtually inifinity.
-- =

Rik Wasmus

Re: OT - an SQL question

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.

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

Re: OT - an SQL question

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

Re: OT - an SQL question

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
==================

Re: OT - an SQL question

Rik Wasmus wrote:
> On Sun, 11 Nov 2007 04:37:02 +0100, Shelly
> wrote:
>
>> What the original coder was do was subselects. This is supported on
>> MySQL
>> 4.1 and above. The version on the server that it is being moved to
>> is 4.0.27, so that is why it didn't work. For the one I posted, there
>> was a simple way of recoding it. As I progressed futher into it,
>> there were more
>> complex cases that required a subselect. Otherwise, it required
>> multiple,
>> separate queries. For example:
>>
>> select
>> ID,
>> (select ArtistName from mARTISTS where tblMain.MnArtist1 =
>> mARTISTS.ArtistID) as Artist1,
>> MnArtist1Desc,
>> (select ArtistName from mARTISTS where tblMain.MnArtist2 =
>> mARTISTS.ArtistID) as Artist2,
>> MnArtist2Desc
>> from tblMain
>> where MnEvent = '22'
>> ORDER BY MnOrder
>
> And that's why you should post in a MySQL group.

I don't have access to one on my news server. That is why I started the
title with OT so that people like Jerry could simply not read it. I
usually keep my posts here on topic and only php (you know that). However,
there comes a time for an occasional exception when seeking help from fellow
posters. The rules are there for all of us to live by, but who among us has
not exceeded the speed limit by at least 5 mph on at least one occasion.
IOW, the "rules" are not cast in stone. We can bend the limits a little on
occasion -- especially when we warn the slower drivers that we intend to
exceed the speed limit a little.

As to your comment about the number of artists, I agree.. That is how I
would have done it if I had designed the database. However, this is a
database that the customer has, and it worked, so I am stuck with it.

Shelly

Re: OT - an SQL question

Rik Wasmus wrote:
> On Sun, 11 Nov 2007 04:37:02 +0100, Shelly
> wrote:
>
>> What the original coder was do was subselects. This is supported on
>> MySQL
>> 4.1 and above. The version on the server that it is being moved to is
>> 4.0.27, so that is why it didn't work. For the one I posted, there was a
>> simple way of recoding it. As I progressed futher into it, there were
>> more
>> complex cases that required a subselect. Otherwise, it required
>> multiple,
>> separate queries. For example:
>>
>> select
>> ID,
>> (select ArtistName from mARTISTS where tblMain.MnArtist1 =
>> mARTISTS.ArtistID) as Artist1,
>> MnArtist1Desc,
>> (select ArtistName from mARTISTS where tblMain.MnArtist2 =
>> mARTISTS.ArtistID) as Artist2,
>> MnArtist2Desc
>> from tblMain
>> where MnEvent = '22'
>> ORDER BY MnOrder
>
> And that's why you should post in a MySQL group. This query still does
> not require a subselect.
>
> SELECT m.ID, a1.ArtistName, m.MnArtist1Desc, a2.ArtistName,
> m.MnArtist2Desc
> FROM tblMain m
> LEFT JOIN mARTISTS a1
> ON a1.ArtistId = m.MnArtist1
> LEFT JOIN mARTISTS a2
> ON a2.ArtistId = m.MnArtist2
> WHERE m.MnEvent = '22';
> ORDER BY m.MnOrder
>
> ... allthough this seems limited to 2 Artists. Fine if the business
> logic requires there are always 2, if not, the relation should be moved
> to a relational tabel containing an tblMain ID and an ArtistId, so you
> can have any number of artists from 0 to virtually inifinity.

Rik,

As long as people keep answering his SQL questions he won't make any
attempt to locate a MySQL group. Not having it on his server is a
piss-poor excuse. There are too many other ways he can get to it.

And there are MySQL mailing lists he could use.

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

Re: OT - an SQL question

"Shelly" wrote in message
news:13jf8ug9p75fo8a@corp.supernews.com...
> Rik Wasmus wrote:
>> On Sun, 11 Nov 2007 04:37:02 +0100, Shelly
>> wrote:
>>
>>> What the original coder was do was subselects. This is supported on
>>> MySQL
>>> 4.1 and above. The version on the server that it is being moved to
>>> is 4.0.27, so that is why it didn't work. For the one I posted, there
>>> was a simple way of recoding it. As I progressed futher into it,
>>> there were more
>>> complex cases that required a subselect. Otherwise, it required
>>> multiple,
>>> separate queries. For example:
>>>
>>> select
>>> ID,
>>> (select ArtistName from mARTISTS where tblMain.MnArtist1 =
>>> mARTISTS.ArtistID) as Artist1,
>>> MnArtist1Desc,
>>> (select ArtistName from mARTISTS where tblMain.MnArtist2 =
>>> mARTISTS.ArtistID) as Artist2,
>>> MnArtist2Desc
>>> from tblMain
>>> where MnEvent = '22'
>>> ORDER BY MnOrder
>>
>> And that's why you should post in a MySQL group.
>
> I don't have access to one on my news server. That is why I started the
> title with OT so that people like Jerry could simply not read it. I
> usually keep my posts here on topic and only php (you know that).
> However, there comes a time for an occasional exception when seeking help
> from fellow posters. The rules are there for all of us to live by, but
> who among us has not exceeded the speed limit by at least 5 mph on at
> least one occasion. IOW, the "rules" are not cast in stone. We can bend
> the limits a little on occasion -- especially when we warn the slower
> drivers that we intend to exceed the speed limit a little.
>
> As to your comment about the number of artists, I agree.. That is how I
> would have done it if I had designed the database. However, this is a
> database that the customer has, and it worked, so I am stuck with it.

shelly, as blat originally first stated, the two are essentially the same
query. however, most db's will perform a completely different execution plan
when the sub-selects are part of the main select. much better performance is
had when proper joining is done, as you showed in your second post. plus, it
is far easier to read because you know where the relationships (joins) are
made - and made *once*...as apposed to each sub-select call as seen above as
Artist1, Artist2.

proper joining will reduce the number of table scans and reduce the number
of opportunities to mess up a column if you need to change anything related
to this specific query...say, between the def. of Artist1 and Artist2. there
are other great reasonses, but these are two clearly good ones.

cheers.

Re: OT - an SQL question

On Nov 11, 2:53 am, "Shelly" wrote:
> ZeldorBlat wrote:
> > On Nov 10, 8:29 pm, "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.
>
> > They should be the same. I generally see the first type of query when
> > someone doesn't really understand joins. It also typically results in
> > horrible performance.
>
> Hmmm. I learned the second type about 25 years ago and is always how I do
> those joins. My client's customer changed servers and the new server has an
> older version of MySQL. They ran into problems with many queries. I
> started looking at the code, and the first one I came accross was the first
> version (longer in length, I stripped it down for the posting). I copied
> that code and went to phpmyadmin and did a sql query. It barfed and
> complained mightily on the sub-select. I tried to analyze what the original
> coder was intending to do, and came up with the second one (I wrote that
> one). That one worked. I just wanted some verification from other
> professionals that I was reading the original correctly in what the coder
> was intending to do -- before I proceeded on my merry way modifying code in
> some twenty modules.
>
> --
> Shelly

Theoretically, the two give the same results, because they're both
Descartes' product
of all rows. However, as Steve pointed out, SQL server might make a
different execution
plan if it counters a normal join. There are, however, more problems
with this - what happens
if the subquery returns more than one result? Also, I think sql server
will do "jumps" on each
row, instead of multiplying them all and then remove the ones not
meeting the given criteria.

Re: OT - an SQL question

On Nov 12, 1:00 am, Jerry Stuckle 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

Re: OT - an SQL question

Darko wrote:
> On Nov 12, 1:00 am, Jerry Stuckle 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
==================

Re: OT - an SQL question

Jerry Stuckle wrote:
>
> Hey - I call them like I see them.

Me too, and I don't give a f-k about what self-appointed newsgroup nazis
think. Oops, I just realized I am breaking my own rule of responding to
you, but, oh well, rules were made to be broken.

Hey somebody, go get Jerry a very big ladder. He needs it to get down from
that super-high horse in order to take a crap once he loosens his extremely
tight ass.

Jerry, if you are to "stooooopid" to know what "OT - " means, then I can't
help it if you deign to read it. It was put there so that YOU wouldn't
waste your time, but since all you seem to want to do is bitch, bitch,
bitch, then I guess I wasted MY time putting it there.

--
Shelly

Re: OT - an SQL question

Shelly wrote:
> Jerry Stuckle wrote:
>> Hey - I call them like I see them.
>
> Me too, and I don't give a f-k about what self-appointed newsgroup nazis
> think. Oops, I just realized I am breaking my own rule of responding to
> you, but, oh well, rules were made to be broken.
>
> Hey somebody, go get Jerry a very big ladder. He needs it to get down from
> that super-high horse in order to take a crap once he loosens his extremely
> tight ass.
>
> Jerry, if you are to "stooooopid" to know what "OT - " means, then I can't
> help it if you deign to read it. It was put there so that YOU wouldn't
> waste your time, but since all you seem to want to do is bitch, bitch,
> bitch, then I guess I wasted MY time putting it there.
>

And it's no frigging excuse for you to post mysql questions here when
there are good mysql newsgroups for you to post in.

Get it through your stoopid head - THIS IS NOT YOUR PERSONAL HELP GROUP!

POST YOUR MYSQL QUESTIONS IN A MYSQL NEWSGROUP AND STOP BUGGING US WITH
YOUR LAZINESS!

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

Re: OT - an SQL question

I wish to thank:
Zeldorblat,
Rik Wasmus,
Darko,
Anr Daemon, and
Steve
for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
have noticed that this thank you is top posted.

--
Shelly



Jerry Stuckle wrote:
> Shelly wrote:
>> Jerry Stuckle wrote:
>>> Hey - I call them like I see them.
>>
>> Me too, and I don't give a f-k about what self-appointed newsgroup
>> nazis think. Oops, I just realized I am breaking my own rule of
>> responding to you, but, oh well, rules were made to be broken.
>>
>> Hey somebody, go get Jerry a very big ladder. He needs it to get
>> down from that super-high horse in order to take a crap once he
>> loosens his extremely tight ass.
>>
>> Jerry, if you are to "stooooopid" to know what "OT - " means, then I
>> can't help it if you deign to read it. It was put there so that YOU
>> wouldn't waste your time, but since all you seem to want to do is
>> bitch, bitch, bitch, then I guess I wasted MY time putting it there.
>>
>
> And it's no frigging excuse for you to post mysql questions here when
> there are good mysql newsgroups for you to post in.
>
> Get it through your stoopid head - THIS IS NOT YOUR PERSONAL HELP
> GROUP!
> POST YOUR MYSQL QUESTIONS IN A MYSQL NEWSGROUP AND STOP BUGGING US
> WITH YOUR LAZINESS!

Re: OT - an SQL question

Post removed (X-No-Archive: yes)

Re: OT - an SQL question

Gary L. Burnore wrote:
> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> top posted like an ignorant moron
> and wrote:
>
>> I wish to thank:
>> Zeldorblat,
>> Rik Wasmus,
>> Darko,
>> Anr Daemon, and
>> Steve
>> for your help. As for Jerry, if you didn't read "OT"s, then you
>> wouldn't have noticed that this thank you is top posted.
>
> Maybe you should start using [TP] so we know you don't care?

That was top posted for the benefit of one, and only one, person. Except
for "thank you's", I always in-line post.

--
Shelly

Re: OT - an SQL question

Shelly wrote:
> I wish to thank:
> Zeldorblat,
> Rik Wasmus,
> Darko,
> Anr Daemon, and
> Steve
> for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
> have noticed that this thank you is top posted.
>

That's the spirit!

Re: OT - an SQL question

Good idea!


Gary L. Burnore wrote:
> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> top posted like an ignorant moron
> and wrote:
>
>> I wish to thank:
>> Zeldorblat,
>> Rik Wasmus,
>> Darko,
>> Anr Daemon, and
>> Steve
>> for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
>> have noticed that this thank you is top posted.
>
> Maybe you should start using [TP] so we know you don't care?
>

Re: OT - an SQL question

Shelly wrote:
> I wish to thank:
> Zeldorblat,
> Rik Wasmus,
> Darko,
> Anr Daemon, and
> Steve
> for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
> have noticed that this thank you is top posted.
>

And you are a horse's ass, Shelly. This is even more proof.

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

Re: OT - an SQL question

Take a chill pill dude an calm down .






> > I wish to thank:
> > Zeldorblat,
> > Rik Wasmus,
> > Darko,
> > Anr Daemon, and
> > Steve
> > for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
> > have noticed
> >
>
> And you are a horse's ass, Shelly. This is even more proof.
>

Re: OT - an SQL question

"Darko" wrote in message
news:1194836894.792496.171840@c30g2000hsa.googlegroups.com.. .
> On Nov 11, 2:53 am, "Shelly" wrote:
>> ZeldorBlat wrote:
>> > On Nov 10, 8:29 pm, "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.
>>
>> > They should be the same. I generally see the first type of query when
>> > someone doesn't really understand joins. It also typically results in
>> > horrible performance.
>>
>> Hmmm. I learned the second type about 25 years ago and is always how I
>> do
>> those joins. My client's customer changed servers and the new server has
>> an
>> older version of MySQL. They ran into problems with many queries. I
>> started looking at the code, and the first one I came accross was the
>> first
>> version (longer in length, I stripped it down for the posting). I copied
>> that code and went to phpmyadmin and did a sql query. It barfed and
>> complained mightily on the sub-select. I tried to analyze what the
>> original
>> coder was intending to do, and came up with the second one (I wrote that
>> one). That one worked. I just wanted some verification from other
>> professionals that I was reading the original correctly in what the coder
>> was intending to do -- before I proceeded on my merry way modifying code
>> in
>> some twenty modules.
>>
>> --
>> Shelly
>
> Theoretically, the two give the same results, because they're both
> Descartes' product
> of all rows. However, as Steve pointed out, SQL server might make a
> different execution
> plan if it counters a normal join. There are, however, more problems
> with this - what happens
> if the subquery returns more than one result? Also, I think sql server
> will do "jumps" on each
> row, instead of multiplying them all and then remove the ones not
> meeting the given criteria.

do you mean a 'cartesian' product? all rows in a * all rows in b == total
rows joined? i don't think that's what's going on here. it's a 'good' join
as a sub-select because it there is criteria on the sub-select that will
match rows with equality.

you are correct though re. multiple rows retuned in the sub-select. that's
another reason to do a formal join.

Re: OT - an SQL question

"Darko" wrote in message
news:1194836950.029815.172190@22g2000hsm.googlegroups.com...
> On Nov 12, 1:00 am, Jerry Stuckle 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.
:)

Re: OT - an SQL question

ROFL

"Shelly" wrote in message
news:13jgetqcccdesce@corp.supernews.com...
>I wish to thank:
> Zeldorblat,
> Rik Wasmus,
> Darko,
> Anr Daemon, and
> Steve
> for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
> have noticed that this thank you is top posted.
>
> --
> Shelly
>
>
>
> Jerry Stuckle wrote:
>> Shelly wrote:
>>> Jerry Stuckle wrote:
>>>> Hey - I call them like I see them.
>>>
>>> Me too, and I don't give a f-k about what self-appointed newsgroup
>>> nazis think. Oops, I just realized I am breaking my own rule of
>>> responding to you, but, oh well, rules were made to be broken.
>>>
>>> Hey somebody, go get Jerry a very big ladder. He needs it to get
>>> down from that super-high horse in order to take a crap once he
>>> loosens his extremely tight ass.
>>>
>>> Jerry, if you are to "stooooopid" to know what "OT - " means, then I
>>> can't help it if you deign to read it. It was put there so that YOU
>>> wouldn't waste your time, but since all you seem to want to do is
>>> bitch, bitch, bitch, then I guess I wasted MY time putting it there.
>>>
>>
>> And it's no frigging excuse for you to post mysql questions here when
>> there are good mysql newsgroups for you to post in.
>>
>> Get it through your stoopid head - THIS IS NOT YOUR PERSONAL HELP
>> GROUP!
>> POST YOUR MYSQL QUESTIONS IN A MYSQL NEWSGROUP AND STOP BUGGING US
>> WITH YOUR LAZINESS!
>
>

Re: OT - an SQL question

'horse's ass'...ROF.

and since when have you EVER relied on PROOF to champion ANY of your
opinions, jerry?


"Jerry Stuckle" wrote in message
news:JI2dnWL93Oli16XanZ2dnUVZ_qPinZ2d@comcast.com...
> Shelly wrote:
>> I wish to thank:
>> Zeldorblat,
>> Rik Wasmus,
>> Darko,
>> Anr Daemon, and
>> Steve
>> for your help. As for Jerry, if you didn't read "OT"s, then you wouldn't
>> have noticed that this thank you is top posted.
>>
>
> And you are a horse's ass, Shelly. This is even more proof.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
>

Re: OT - an SQL question

Steve wrote:
> "Darko" wrote in message
> news:1194836950.029815.172190@22g2000hsm.googlegroups.com...
>> On Nov 12, 1:00 am, Jerry Stuckle 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.
> :)
>
>
>

Maybe because that's how you acted?

You had no arguments. Rather, you kept trying to change the subject and
claim I said things I never did. Typical of your behavior when you
don't have an argument. As anyone who goes back and looks at the thread
can see.

I finally cut it off because you couldn't support your argument.

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

Re: OT - an SQL question

"Jerry Stuckle" wrote in message
news:7eCdnTnJ0-C7_qXanZ2dnUVZ_tjinZ2d@comcast.com...
> Steve wrote:
>> "Darko" wrote in message
>> news:1194836950.029815.172190@22g2000hsm.googlegroups.com...
>>> On Nov 12, 1:00 am, Jerry Stuckle 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. :)
>
> Maybe because that's how you acted?

jerry, you've seen my posts. i was quite polite. before the final post, i
didn't even levy anything remotely vulgar. and in the final post when i did,
it was frustration that was not directed at you. go back at re-read that
post.

> You had no arguments.

jerry, in all of my at least 7 posts, there were multiple arguments made
*and* supported. your argument was that you didn't like the way i formatted
sql. your reasoning was because my way took up screen space. i made several
counters to that which made sense to more than just me. but, THAT was where
your support ended.

don't tell me i had NO arguments. especially when i clearly worked circles
around your single argument. in the end, you opinion revolved around 'jerry
likes it this way because jerry likes it this way'...and, i really don't
care what jerry likes or dislikes.

> Rather, you kept trying to change the subject and claim I said things I
> never did.

you chimed in with a subject change. i kept trying to get you to see the
point was formatting sql, not HOW STEVE FORMATS SQL. you snipped out all of
that and in its place, posted ''. great rebuttal. lol.

> Typical of your behavior when you don't have an argument. As anyone who
> goes back and looks at the thread can see.

yeah, you should only hope no one does. then you'll be defending your
audacious attitude in more than JUST THIS THREAD today. roflmao!

> I finally cut it off because you couldn't support your argument.

dude! were you on the SAME subject, you'd notice i was. however on YOUR
subject - an irrelevant tangent, btw - there's no point in arguing that my
opinion is better or worse than someone elses. get over it already!

screen-space?! really jerry? THAT is supporting an argument? i'm busting a
gut...all over again!

Re: OT - an SQL question

"Jerry Stuckle" wrote in message
news:7eCdnTnJ0-C7_qXanZ2dnUVZ_tjinZ2d@comcast.com...
> Steve wrote:
>> "Darko" wrote in message
>> news:1194836950.029815.172190@22g2000hsm.googlegroups.com...
>>> On Nov 12, 1:00 am, Jerry Stuckle wrote:
>>>> Shelly wrote:
>>>>> Jerry Stuckle wrote:
>>>>>> Shelly wrote:
> Maybe because that's how you acted?
>
> You had no arguments. Rather, you kept trying to change the subject and
> claim I said things I never did. Typical of your behavior when you don't
> have an argument. As anyone who goes back and looks at the thread can
> see.
>
> I finally cut it off because you couldn't support your argument.

and jerry, let me end with restating the following that you won't address.
it's the false accusation that can be refuted WITH PROOF. but again, and
that which lead me to state here that you do not care for proof, you just
shut down when you can't back yourself up. here it is:

====

jerry stuckle:

> And you should see who started the insults.

me:

really? make a bet with you. go to the earliest thread that you can and
quote the insult i flung at you. i'll do the same. the one who has the
earliest date stamp wins, ok?

let's get started...

Message-ID: <8YCdndIBAbkzsq7anZ2dnUVZ_hmtnZ2d@comcast.com>

jerry: "Don't be an asshole again, Steve"
jerry: "Yep, programmers with any sense don't do it that way."
jerry: "I said the way you did it is stupid."
jerry: "But like anyone with no argument, you keep
trying to put words into my mouth."

wow, i almost quoted the ENTIRE response dated: 2007-11-08 11:47 AM !!!

ok, now it's your turn. :)

Re: OT - an SQL question

On Nov 12, 3:13 pm, "Steve" wrote:
> "Darko" wrote in message
>
> news:1194836894.792496.171840@c30g2000hsa.googlegroups.com.. .
>
>
>
> > On Nov 11, 2:53 am, "Shelly" wrote:
> >> ZeldorBlat wrote:
> >> > On Nov 10, 8:29 pm, "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.
>
> >> > They should be the same. I generally see the first type of query when
> >> > someone doesn't really understand joins. It also typically results in
> >> > horrible performance.
>
> >> Hmmm. I learned the second type about 25 years ago and is always how I
> >> do
> >> those joins. My client's customer changed servers and the new server has
> >> an
> >> older version of MySQL. They ran into problems with many queries. I
> >> started looking at the code, and the first one I came accross was the
> >> first
> >> version (longer in length, I stripped it down for the posting). I copied
> >> that code and went to phpmyadmin and did a sql query. It barfed and
> >> complained mightily on the sub-select. I tried to analyze what the
> >> original
> >> coder was intending to do, and came up with the second one (I wrote that
> >> one). That one worked. I just wanted some verification from other
> >> professionals that I was reading the original correctly in what the coder
> >> was intending to do -- before I proceeded on my merry way modifying code
> >> in
> >> some twenty modules.
>
> >> --
> >> Shelly
>
> > Theoretically, the two give the same results, because they're both
> > Descartes' product
> > of all rows. However, as Steve pointed out, SQL server might make a
> > different execution
> > plan if it counters a normal join. There are, however, more problems
> > with this - what happens
> > if the subquery returns more than one result? Also, I think sql server
> > will do "jumps" on each
> > row, instead of multiplying them all and then remove the ones not
> > meeting the given criteria.
>
> do you mean a 'cartesian' product? all rows in a * all rows in b == total
> rows joined? i don't think that's what's going on here. it's a 'good' join
> as a sub-select because it there is criteria on the sub-select that will
> match rows with equality.
>
> you are correct though re. multiple rows retuned in the sub-select. that's
> another reason to do a formal join.

Yes, I meant Cartesian. Cartesian is names after Descartes, so I said
it that way.

Re: OT - an SQL question

On Nov 12, 1:17 pm, "Shelly" wrote:
> Gary L. Burnore wrote:
> > On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> > top posted like an ignorant moron
> > and wrote:
>
> >> I wish to thank:
> >> Zeldorblat,
> >> Rik Wasmus,
> >> Darko,
> >> Anr Daemon, and
> >> Steve
> >> for your help. As for Jerry, if you didn't read "OT"s, then you
> >> wouldn't have noticed that this thank you is top posted.
>
> > Maybe you should start using [TP] so we know you don't care?
>
> That was top posted for the benefit of one, and only one, person. Except
> for "thank you's", I always in-line post.
>
> --
> Shelly

You're welcome, really, but please don't think we encourage you to do
off topics,
even when supplied with OT in the title; it's not a big excuse, and is
generally
not tolerated in any newsgroup.

I might have criticized Jerry for "asshole" words, but I wouldn't like
to be misunderstood
as support to you, because Jerry is definitely right in the whole
issue, but he just
doesn't realize that swearing collides with netiquette just as well as
writing off topics.

Re: OT - an SQL question

"Darko" wrote in message
news:1194882858.888294.110260@v2g2000hsf.googlegroups.com...
> On Nov 12, 3:13 pm, "Steve" wrote:
>> "Darko" wrote in message
>>
>> news:1194836894.792496.171840@c30g2000hsa.googlegroups.com.. .
>>
>>
>>
>> > On Nov 11, 2:53 am, "Shelly" wrote:
>> >> ZeldorBlat wrote:
>> >> > On Nov 10, 8:29 pm, "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.
>>
>> >> > They should be the same. I generally see the first type of query
>> >> > when
>> >> > someone doesn't really understand joins. It also typically results
>> >> > in
>> >> > horrible performance.
>>
>> >> Hmmm. I learned the second type about 25 years ago and is always how
>> >> I
>> >> do
>> >> those joins. My client's customer changed servers and the new server
>> >> has
>> >> an
>> >> older version of MySQL. They ran into problems with many queries. I
>> >> started looking at the code, and the first one I came accross was the
>> >> first
>> >> version (longer in length, I stripped it down for the posting). I
>> >> copied
>> >> that code and went to phpmyadmin and did a sql query. It barfed and
>> >> complained mightily on the sub-select. I tried to analyze what the
>> >> original
>> >> coder was intending to do, and came up with the second one (I wrote
>> >> that
>> >> one). That one worked. I just wanted some verification from other
>> >> professionals that I was reading the original correctly in what the
>> >> coder
>> >> was intending to do -- before I proceeded on my merry way modifying
>> >> code
>> >> in
>> >> some twenty modules.
>>
>> >> --
>> >> Shelly
>>
>> > Theoretically, the two give the same results, because they're both
>> > Descartes' product
>> > of all rows. However, as Steve pointed out, SQL server might make a
>> > different execution
>> > plan if it counters a normal join. There are, however, more problems
>> > with this - what happens
>> > if the subquery returns more than one result? Also, I think sql server
>> > will do "jumps" on each
>> > row, instead of multiplying them all and then remove the ones not
>> > meeting the given criteria.
>>
>> do you mean a 'cartesian' product? all rows in a * all rows in b == total
>> rows joined? i don't think that's what's going on here. it's a 'good'
>> join
>> as a sub-select because it there is criteria on the sub-select that will
>> match rows with equality.
>>
>> you are correct though re. multiple rows retuned in the sub-select.
>> that's
>> another reason to do a formal join.
>
> Yes, I meant Cartesian. Cartesian is names after Descartes, so I said
> it that way.

makes sense.

Re: OT - an SQL question

"Darko" wrote in message
news:1194883114.254275.311400@19g2000hsx.googlegroups.com...
> On Nov 12, 1:17 pm, "Shelly" wrote:
>> Gary L. Burnore wrote:
>> > On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>> > top posted like an ignorant moron
>> > and wrote:
>>
>> >> I wish to thank:
>> >> Zeldorblat,
>> >> Rik Wasmus,
>> >> Darko,
>> >> Anr Daemon, and
>> >> Steve
>> >> for your help. As for Jerry, if you didn't read "OT"s, then you
>> >> wouldn't have noticed that this thank you is top posted.
>>
>> > Maybe you should start using [TP] so we know you don't care?
>>
>> That was top posted for the benefit of one, and only one, person. Except
>> for "thank you's", I always in-line post.
>>
>> --
>> Shelly
>
> You're welcome, really, but please don't think we encourage you to do
> off topics,
> even when supplied with OT in the title; it's not a big excuse, and is
> generally
> not tolerated in any newsgroup.
>
> I might have criticized Jerry for "asshole" words, but I wouldn't like
> to be misunderstood
> as support to you, because Jerry is definitely right in the whole
> issue, but he just
> doesn't realize that swearing collides with netiquette just as well as
> writing off topics.

i've been where shel has been though. w/lamp is almost a consolidated
subject. however, if you have a question about something *other than* apache
or php, you could wait for days getting a response. there are a scarce few
who use php on windows but plenty of windows usenet groups. however, if you
post your question here about php/windows config, you'll get a quick
response - if you weed out the jerry stuckle diatribes. same for
mysql...there just aren't many people checking that group as regularly -
much less, qualified respondents.

just ignore those to whom you think should post elsewhere. i mean, not
getting a response is the reason for shel (or others) to post the question
here in the first place. right?

the only time i have a problem is when it is clear the op has NOT rtfm
and/or posts ot here without the thought of posting elsewhere more
appropriate to the nature of the question. as it is, shel has pased both my
criteria here...so, i tried to give the best answer i could in the most
polite fashion i could.

cheers.

Re: OT - an SQL question

Darko wrote:
> On Nov 12, 1:17 pm, "Shelly" wrote:
>> Gary L. Burnore wrote:
>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>> top posted like an ignorant moron
>>> and wrote:
>>
>>>> I wish to thank:
>>>> Zeldorblat,
>>>> Rik Wasmus,
>>>> Darko,
>>>> Anr Daemon, and
>>>> Steve
>>>> for your help. As for Jerry, if you didn't read "OT"s, then you
>>>> wouldn't have noticed that this thank you is top posted.
>>
>>> Maybe you should start using [TP] so we know you don't care?
>>
>> That was top posted for the benefit of one, and only one, person.
>> Except for "thank you's", I always in-line post.
>>
>> --
>> Shelly
>
> You're welcome, really, but please don't think we encourage you to do
> off topics,

I don't.

> even when supplied with OT in the title; it's not a big excuse, and is
> generally
> not tolerated in any newsgroup.

I agree, and so try to keep it to an absolute minimum. It is only when I
can't get at the answer through regular channels.....

> I might have criticized Jerry for "asshole" words, but I wouldn't like
> to be misunderstood
> as support to you, because Jerry is definitely right in the whole
> issue, but he just

I know he is concerning the off-topics and top-posting. I agree with him on
those. This reminds me of something. I used to work for a French company
and every three months I would go to Paris for a week on business. They
told me the difference between the Germans, the French and the Americans.

To the Germans a schedule is just that. You stick to the schedule --- even
it no longer makes sense.
To the French a schedule is a suggestion.
To the Americans a schedule is just that, but you can change the schedule to
changing conditions.

I like to think of myself as American. I guess Jerry is "German".

Another way of looking at it is that there is always a small percentage of
bugs and stuff in all the processed food we eat. It is kept below some very
low level. If we insisted on absolutely zero level, then we would starve.
I like to eat.

So while I generally follow the rules, there ARE exceptions. To minimize
the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
people can't drive.

> doesn't realize that swearing collides with netiquette just as well as
> writing off topics.

YOU CAN SAY THAT AGAIN.

--
Shelly
(notice that the sig follows netiquette (once I learned about it).

Re: OT - an SQL question

Just look for the google return address - it's a sure bet, the post will be
top-posted.

But times are a-changing, and a new breed is coming up in the ranks.
They top-post.
We can fight it, or we can capitalize on it.




"The Natural Philosopher" wrote in message
news:1194870434.66200.2@demeter.uk.clara.net...
> Good idea!
>
>
> Gary L. Burnore wrote:
>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>> top posted like an ignorant moron
>> and wrote:
>>
>>> I wish to thank:
>>> Zeldorblat,
>>> Rik Wasmus,
>>> Darko,
>>> Anr Daemon, and
>>> Steve
>>> for your help. As for Jerry, if you didn't read "OT"s, then you
>>> wouldn't have noticed that this thank you is top posted.
>>
>> Maybe you should start using [TP] so we know you don't care?
>>

Re: OT - an SQL question

On Nov 12, 7:20 pm, "Shelly" wrote:
> Darko wrote:
> > On Nov 12, 1:17 pm, "Shelly" wrote:
> >> Gary L. Burnore wrote:
> >>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> >>> top posted like an ignorant moron
> >>> and wrote:
>
> >>>> I wish to thank:
> >>>> Zeldorblat,
> >>>> Rik Wasmus,
> >>>> Darko,
> >>>> Anr Daemon, and
> >>>> Steve
> >>>> for your help. As for Jerry, if you didn't read "OT"s, then you
> >>>> wouldn't have noticed that this thank you is top posted.
>
> >>> Maybe you should start using [TP] so we know you don't care?
>
> >> That was top posted for the benefit of one, and only one, person.
> >> Except for "thank you's", I always in-line post.
>
> >> --
> >> Shelly
>
> > You're welcome, really, but please don't think we encourage you to do
> > off topics,
>
> I don't.
>
> > even when supplied with OT in the title; it's not a big excuse, and is
> > generally
> > not tolerated in any newsgroup.
>
> I agree, and so try to keep it to an absolute minimum. It is only when I
> can't get at the answer through regular channels.....
>
> > I might have criticized Jerry for "asshole" words, but I wouldn't like
> > to be misunderstood
> > as support to you, because Jerry is definitely right in the whole
> > issue, but he just
>
> I know he is concerning the off-topics and top-posting. I agree with him on
> those. This reminds me of something. I used to work for a French company
> and every three months I would go to Paris for a week on business. They
> told me the difference between the Germans, the French and the Americans.
>
> To the Germans a schedule is just that. You stick to the schedule --- even
> it no longer makes sense.
> To the French a schedule is a suggestion.
> To the Americans a schedule is just that, but you can change the schedule to
> changing conditions.
>
> I like to think of myself as American. I guess Jerry is "German".
>
> Another way of looking at it is that there is always a small percentage of
> bugs and stuff in all the processed food we eat. It is kept below some very
> low level. If we insisted on absolutely zero level, then we would starve.
> I like to eat.
>
> So while I generally follow the rules, there ARE exceptions. To minimize
> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
> people can't drive.
>
> > doesn't realize that swearing collides with netiquette just as well as
> > writing off topics.
>
> YOU CAN SAY THAT AGAIN.

You'd better agree to everything Jerry says, Shelly.
Or else, he will beat you up as he did with his wife:
Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )

Re: OT - an SQL question

1001 Webs wrote:
> On Nov 12, 7:20 pm, "Shelly" wrote:
>> Darko wrote:
>>> On Nov 12, 1:17 pm, "Shelly" wrote:
>>>> Gary L. Burnore wrote:
>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>> top posted like an ignorant moron
>>>>> and wrote:
>>>>>> I wish to thank:
>>>>>> Zeldorblat,
>>>>>> Rik Wasmus,
>>>>>> Darko,
>>>>>> Anr Daemon, and
>>>>>> Steve
>>>>>> for your help. As for Jerry, if you didn't read "OT"s, then you
>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>> Maybe you should start using [TP] so we know you don't care?
>>>> That was top posted for the benefit of one, and only one, person.
>>>> Except for "thank you's", I always in-line post.
>>>> --
>>>> Shelly
>>> You're welcome, really, but please don't think we encourage you to do
>>> off topics,
>> I don't.
>>
>>> even when supplied with OT in the title; it's not a big excuse, and is
>>> generally
>>> not tolerated in any newsgroup.
>> I agree, and so try to keep it to an absolute minimum. It is only when I
>> can't get at the answer through regular channels.....
>>
>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>> to be misunderstood
>>> as support to you, because Jerry is definitely right in the whole
>>> issue, but he just
>> I know he is concerning the off-topics and top-posting. I agree with him on
>> those. This reminds me of something. I used to work for a French company
>> and every three months I would go to Paris for a week on business. They
>> told me the difference between the Germans, the French and the Americans.
>>
>> To the Germans a schedule is just that. You stick to the schedule --- even
>> it no longer makes sense.
>> To the French a schedule is a suggestion.
>> To the Americans a schedule is just that, but you can change the schedule to
>> changing conditions.
>>
>> I like to think of myself as American. I guess Jerry is "German".
>>
>> Another way of looking at it is that there is always a small percentage of
>> bugs and stuff in all the processed food we eat. It is kept below some very
>> low level. If we insisted on absolutely zero level, then we would starve.
>> I like to eat.
>>
>> So while I generally follow the rules, there ARE exceptions. To minimize
>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>> people can't drive.
>>
>>> doesn't realize that swearing collides with netiquette just as well as
>>> writing off topics.
>> YOU CAN SAY THAT AGAIN.
>
> You'd better agree to everything Jerry says, Shelly.
> Or else, he will beat you up as he did with his wife:
> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )
>
>

ROFLMAO! This troll is following me around all over the internet now!

For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
Spain. He thinks he's a web designer/developer, but he isn't.

He's just another troll. But he isn't even as smart as the hatter.

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

Re: OT - an SQL question

"Jerry Stuckle" wrote in message
news:D92dnf8lXdPkB6TanZ2dnUVZ_u3inZ2d@comcast.com...
> 1001 Webs wrote:
>> On Nov 12, 7:20 pm, "Shelly" wrote:
>>> Darko wrote:
>>>> On Nov 12, 1:17 pm, "Shelly" wrote:
>>>>> Gary L. Burnore wrote:
>>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>>> top posted like an ignorant moron
>>>>>> and wrote:
>>>>>>> I wish to thank:
>>>>>>> Zeldorblat,
>>>>>>> Rik Wasmus,
>>>>>>> Darko,
>>>>>>> Anr Daemon, and
>>>>>>> Steve
>>>>>>> for your help. As for Jerry, if you didn't read "OT"s, then you
>>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>>> Maybe you should start using [TP] so we know you don't care?
>>>>> That was top posted for the benefit of one, and only one, person.
>>>>> Except for "thank you's", I always in-line post.
>>>>> --
>>>>> Shelly
>>>> You're welcome, really, but please don't think we encourage you to do
>>>> off topics,
>>> I don't.
>>>
>>>> even when supplied with OT in the title; it's not a big excuse, and is
>>>> generally
>>>> not tolerated in any newsgroup.
>>> I agree, and so try to keep it to an absolute minimum. It is only when
>>> I
>>> can't get at the answer through regular channels.....
>>>
>>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>>> to be misunderstood
>>>> as support to you, because Jerry is definitely right in the whole
>>>> issue, but he just
>>> I know he is concerning the off-topics and top-posting. I agree with
>>> him on
>>> those. This reminds me of something. I used to work for a French
>>> company
>>> and every three months I would go to Paris for a week on business. They
>>> told me the difference between the Germans, the French and the
>>> Americans.
>>>
>>> To the Germans a schedule is just that. You stick to the schedule ---
>>> even
>>> it no longer makes sense.
>>> To the French a schedule is a suggestion.
>>> To the Americans a schedule is just that, but you can change the
>>> schedule to
>>> changing conditions.
>>>
>>> I like to think of myself as American. I guess Jerry is "German".
>>>
>>> Another way of looking at it is that there is always a small percentage
>>> of
>>> bugs and stuff in all the processed food we eat. It is kept below some
>>> very
>>> low level. If we insisted on absolutely zero level, then we would
>>> starve.
>>> I like to eat.
>>>
>>> So while I generally follow the rules, there ARE exceptions. To
>>> minimize
>>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>>> people can't drive.
>>>
>>>> doesn't realize that swearing collides with netiquette just as well as
>>>> writing off topics.
>>> YOU CAN SAY THAT AGAIN.
>>
>> You'd better agree to everything Jerry says, Shelly.
>> Or else, he will beat you up as he did with his wife:
>> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
>> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
>> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )
>>
>>
>
> ROFLMAO! This troll is following me around all over the internet now!
>
> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
> Spain. He thinks he's a web designer/developer, but he isn't.
>
> He's just another troll. But he isn't even as smart as the hatter.

ooooo! that's probably the worst thing that could be said of another human
being! in fact, i didn't think that was possible. :)

Re: OT - an SQL question

On Nov 13, 1:37 pm, Jerry Stuckle wrote:
> 1001 Webs wrote:
> > On Nov 12, 7:20 pm, "Shelly" wrote:
> >> Darko wrote:
> >>> On Nov 12, 1:17 pm, "Shelly" wrote:
> >>>> Gary L. Burnore wrote:
> >>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> >>>>> top posted like an ignorant moron
> >>>>> and wrote:
> >>>>>> I wish to thank:
> >>>>>> Zeldorblat,
> >>>>>> Rik Wasmus,
> >>>>>> Darko,
> >>>>>> Anr Daemon, and
> >>>>>> Steve
> >>>>>> for your help. As for Jerry, if you didn't read "OT"s, then you
> >>>>>> wouldn't have noticed that this thank you is top posted.
> >>>>> Maybe you should start using [TP] so we know you don't care?
> >>>> That was top posted for the benefit of one, and only one, person.
> >>>> Except for "thank you's", I always in-line post.
> >>>> --
> >>>> Shelly
> >>> You're welcome, really, but please don't think we encourage you to do
> >>> off topics,
> >> I don't.
>
> >>> even when supplied with OT in the title; it's not a big excuse, and is
> >>> generally
> >>> not tolerated in any newsgroup.
> >> I agree, and so try to keep it to an absolute minimum. It is only when I
> >> can't get at the answer through regular channels.....
>
> >>> I might have criticized Jerry for "asshole" words, but I wouldn't like
> >>> to be misunderstood
> >>> as support to you, because Jerry is definitely right in the whole
> >>> issue, but he just
> >> I know he is concerning the off-topics and top-posting. I agree with him on
> >> those. This reminds me of something. I used to work for a French company
> >> and every three months I would go to Paris for a week on business. They
> >> told me the difference between the Germans, the French and the Americans.
>
> >> To the Germans a schedule is just that. You stick to the schedule --- even
> >> it no longer makes sense.
> >> To the French a schedule is a suggestion.
> >> To the Americans a schedule is just that, but you can change the schedule to
> >> changing conditions.
>
> >> I like to think of myself as American. I guess Jerry is "German".
>
> >> Another way of looking at it is that there is always a small percentage of
> >> bugs and stuff in all the processed food we eat. It is kept below some very
> >> low level. If we insisted on absolutely zero level, then we would starve.
> >> I like to eat.
>
> >> So while I generally follow the rules, there ARE exceptions. To minimize
> >> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
> >> people can't drive.
>
> >>> doesn't realize that swearing collides with netiquette just as well as
> >>> writing off topics.
> >> YOU CAN SAY THAT AGAIN.
>
> > You'd better agree to everything Jerry says, Shelly.
> > Or else, he will beat you up as he did with his wife:
> > Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> > Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
> > Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )
>
> ROFLMAO! This troll is following me around all over the internet now!
>
> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
> Spain. He thinks he's a web designer/developer, but he isn't.


Taxpayer Services Division

Entity Name: SMARTECH HOMES, INC.
Dept ID #: D07297567

Principal Office (Current): 9920 BRIXTON LANE, BETHESDA, MD 20817
Resident Agent (Current): JERRY D. STUCKLE, 9920 BRIXTON LANE,
BETHESDA, MD 20817

DEPT. ACTION - FORFEITURE 10/06/2006 12:03-AM
THE ENTITY WAS FORFEITED FOR FAILURE TO FILE PROPERTY RETURN FOR 2005.
For a Maryland entity, its existence has been ended by the State for
some delinquency.

Good Standing: No

-----------------------------------------------------
Kind Regards,

Rafael Martinez-Minuesa

www.1001webs.net
Puerto Marina, Benalmadena,
MALAGA - 29630
Spain
Phone: +34.620443347
EmailAddress: info-at-1001webs.net

Re: OT - an SQL question

1001 Webs wrote:
> On Nov 13, 1:37 pm, Jerry Stuckle wrote:
>> 1001 Webs wrote:
>>> On Nov 12, 7:20 pm, "Shelly" wrote:
>>>> Darko wrote:
>>>>> On Nov 12, 1:17 pm, "Shelly" wrote:
>>>>>> Gary L. Burnore wrote:
>>>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>>>> top posted like an ignorant moron
>>>>>>> and wrote:
>>>>>>>> I wish to thank:
>>>>>>>> Zeldorblat,
>>>>>>>> Rik Wasmus,
>>>>>>>> Darko,
>>>>>>>> Anr Daemon, and
>>>>>>>> Steve
>>>>>>>> for your help. As for Jerry, if you didn't read "OT"s, then you
>>>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>>>> Maybe you should start using [TP] so we know you don't care?
>>>>>> That was top posted for the benefit of one, and only one, person.
>>>>>> Except for "thank you's", I always in-line post.
>>>>>> --
>>>>>> Shelly
>>>>> You're welcome, really, but please don't think we encourage you to do
>>>>> off topics,
>>>> I don't.
>>>>> even when supplied with OT in the title; it's not a big excuse, and is
>>>>> generally
>>>>> not tolerated in any newsgroup.
>>>> I agree, and so try to keep it to an absolute minimum. It is only when I
>>>> can't get at the answer through regular channels.....
>>>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>>>> to be misunderstood
>>>>> as support to you, because Jerry is definitely right in the whole
>>>>> issue, but he just
>>>> I know he is concerning the off-topics and top-posting. I agree with him on
>>>> those. This reminds me of something. I used to work for a French company
>>>> and every three months I would go to Paris for a week on business. They
>>>> told me the difference between the Germans, the French and the Americans.
>>>> To the Germans a schedule is just that. You stick to the schedule --- even
>>>> it no longer makes sense.
>>>> To the French a schedule is a suggestion.
>>>> To the Americans a schedule is just that, but you can change the schedule to
>>>> changing conditions.
>>>> I like to think of myself as American. I guess Jerry is "German".
>>>> Another way of looking at it is that there is always a small percentage of
>>>> bugs and stuff in all the processed food we eat. It is kept below some very
>>>> low level. If we insisted on absolutely zero level, then we would starve.
>>>> I like to eat.
>>>> So while I generally follow the rules, there ARE exceptions. To minimize
>>>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>>>> people can't drive.
>>>>> doesn't realize that swearing collides with netiquette just as well as
>>>>> writing off topics.
>>>> YOU CAN SAY THAT AGAIN.
>>> You'd better agree to everything Jerry says, Shelly.
>>> Or else, he will beat you up as he did with his wife:
>>> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
>>> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
>>> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )
>> ROFLMAO! This troll is following me around all over the internet now!
>>
>> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
>> Spain. He thinks he's a web designer/developer, but he isn't.
>
>
> Taxpayer Services Division
>
> Entity Name: SMARTECH HOMES, INC.
> Dept ID #: D07297567
>
> Principal Office (Current): 9920 BRIXTON LANE, BETHESDA, MD 20817
> Resident Agent (Current): JERRY D. STUCKLE, 9920 BRIXTON LANE,
> BETHESDA, MD 20817
>
> DEPT. ACTION - FORFEITURE 10/06/2006 12:03-AM
> THE ENTITY WAS FORFEITED FOR FAILURE TO FILE PROPERTY RETURN FOR 2005.
> For a Maryland entity, its existence has been ended by the State for
> some delinquency.
>
> Good Standing: No
>
> -----------------------------------------------------
> Kind Regards,
>
> Rafael Martinez-Minuesa
>
> www.1001webs.net
> Puerto Marina, Benalmadena,
> MALAGA - 29630
> Spain
> Phone: +34.620443347
> EmailAddress: info-at-1001webs.net
>
>

Keep trying, loser! ROFLMAO!

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

Re: OT - an SQL question

"1001 Webs" <1001webs@gmail.com> wrote in message
news:1194953139.786525.262500@22g2000hsm.googlegroups.com...
> On Nov 12, 7:20 pm, "Shelly" wrote:

> You'd better agree to everything Jerry says, Shelly.
> Or else, he will beat you up as he did with his wife:
> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> Case Number: 0602SP019022003 Claim Type:DOMESTIC VIOLENCE
> Complaint No: 001(STUCKLE, ELIZABETH M) Vs:(STUCKLE, JERRY D )

No real surprise there - he posted a couple of times that he'd like to see
me killed.
I just hope nobody ever reasearches *my* record.