I have a view
Order Drink Entree Desert
--------------------------------------------------
12 Null Preparing Null
12 Ready NULL NULL
12 NULL NULL Waiting
I want to convert it to:
Order Drink Entree Desert
---------------------------------------------------
12 Ready Preparing Waiting
NULLvalue on each row? Something is very wrong with the design that created this mess. Change theINSERTing code as soon as possible.