It is very interesting to me that most people in this group can't do simple
SQL. Are you viewing MySQL as a simple file system?As long as you do that,
you will
not understand SQL in any dialect. So from now on:
When you have a question about SQL. post the table structures. Uh, "With
Create".
Post some sample data in the form of INSERTS.
Regards,
Rich
--
The journey is the reward.