any bright ideas

From: socgen-crosby <crosby_at_pacific.net.sg>
Date: 1997/04/17
Message-ID: <01bc4adf$980a3720$324118d2@sin03161>#1/1

there are three tables x,y and z
I am trying to achieve following in one update statement update z
set z.a ='O'
where
(select count(*) from x) = (select count(*) from y);

I know above sql statement is syntactically wrong but is there any way of achieving this in single sql statement
(without using any explicit cursors)?
Received on Thu Apr 17 1997 - 00:00:00 CDT