>thax I have test in query analyzer it is work .
>but still don't know why in the view designer prompt error after save ( if test it in view designer is work fine ) anyway thax you !
>(* it prompt ".....not support transaction .....")
I woul guess that it's limitation of View Designer.
--sb--