The solution to your problem is simple: don't attempt to do the final query.
Each of your existing queries are perfectly fine the way they are and give
sensible and meaningful answers. Simply run the 3rd and 4th queries as two
separate queries rather than trying to combine them into one query.
That would work, but I am doing calculations based on them and need both to do the calculations....thanks for the other info...I will read the stuff about join...
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
