Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE asiakas
- SET muutettu = SYSDATE, muuttaja = 'jku', asiakasstatus = '-1'
- WHERE asiakasnro = 12437664
- AND asiakasnro NOT IN (SELECT asiakasnro
- FROM tilaus
- WHERE tilausstatus IN (1, 2))
- AND asiakasnro NOT IN (SELECT maksajanro
- FROM tilaus
- WHERE tilausstatus IN (1, 2));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement