Hello MySQL Users I have a contract table. Each contract has a certain level, which can be in a range from 1-5. This information is stored as a number. There is no additional table for the levels.
I would like to get a list with the amount of contracts of each level - including 0 for the levels with no contracts. Until now I just used : SELECT COUNT(*), level FROM contract GROUP BY level but this is just showing level with contracts. I tried a right join with a table which contains just integer values. Seems like a workaround, but I'm interested in a easier aolution - I bet there is one. Thank you! Jay PS: I'm using Version 4.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]