دو سلکت اخر کوئری اجرا شود و اگر داده ای در هر کدام از سلکت ها برگرداند،نسبت به همان سلکت دستور آپدیت از کامنت خارج و اجرا شود.
–update owners
–set type=’PERSON’
–where id in (select eo.owner_id from Estates_Owners eo join owners o on eo.owner_id=o.id join People ins on ins.id=o.id where o.type=’INSTITUTE’)
–update owners
–set type=’INSTITUTE’
–where id in (select eo.owner_id from Estates_Owners eo join owners o on eo.owner_id=o.id join Institutions ins on ins.id=o.id where o.type=’PERSON’)
–select * from Estates_Owners eo join owners o on eo.owner_id=o.id join People ins on ins.id=o.id where o.type=’INSTITUTE’
–select * from Estates_Owners eo join owners o on eo.owner_id=o.id join Institutions ins on ins.id=o.id where o.type=’PERSON’