Not sure on how exactly variables work in MySQL but I do know that according
to ANSI SQL group bys are done before other things in the query. So your
query would perform the group by then it would do the actual select. This
could be one reason for strange results.
Thanks,
Andrew
From: Vadim
For starters look at pet.petName=petcolor.petName
Try changing it to.
pet.petName=color.petName
You are referencing the color table as petcolor.
Thanks,
Andrew
From: Barry . [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Learner Here Getting Frustraighted
Date: Thu, 08 Apr 2004 14:18:10 +
Hi
Keep in mind you can't use truncate in a transaction though. I experienced
this problem
recently when wanting to delete an entire table and reset my auto increment
values. While
keeping it in a transaction.
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Arthur Radulescu' [EMAIL