It seems that the union has problems when some values returned in the selects are nulls like in left joines. Instead of seeing Nulls the rows inherit the value of the previous row. Which make a real mess. I did how ever found a work around. I use
coalesce(myfield,space(30)) as myfield anywhere a null may be returned. Seems to work ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
