Please Read Before Posting

[sajuks]

Please follow these guidelines when posting to ensure proper and better
guidance in solving your queries.

1)The current production version of MySQL is 5.0, so unless specified otherwise it will be assumed that you are using the MySQL 5.0 version.

2)Use a title which is more meaningful instead of something like "Please HELP!".

3)Be as descriptive as possible so that so that your context is not misunderstood.

4)As far as possible try to post the table structure and some raw data to help assist you in solving your queries.