I tried this out this morning on MySQL 5. It works. Please try this in MySQL 4 and see.
Unless I'm way off, I do not believe your solution will work in 4.x because it doesn't support sub-queries...
thnx,Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
