Help on my simple sql script

[christoperl]

Thank you in advance!
the script is here:

(SELECT categoryId, NULL AS subCategoryId, categoryName, NULL AS subCategoryName, status AS cStatus, NULL AS sStatus FROM categories )
UNION

(SELECT c.categoryId as categoryId, s.subCategoryId as subCategoryId, c.categoryName as categoryName, s.subCategoryName as subCategoryName, c.status AS cStatus, s.status AS sStatus FROM categories AS c RIGHT JOIN subcategories AS s ON c.categoryId =s.categoryId)
ORDER BY categoryName, subCategoryName ASC

[christoperl]

I need to upgrade to 4.0, but 4.0 is stable or not?

[DutchBen]

Yes ... 4.0 is stable ... but what exactly is your question .... huh?