What a pain!!
update PVESUSER.accounts
set (department) = (select department
from PVESUSER.indra i
where i.EMPLOYEENUMBER = PVESUSER.accounts.EMPLOYEENUMBER
)
WHERE EXISTS (SELECT 1
from PVESUSER.indra i
where i.EMPLOYEENUMBER = PVESUSER.accounts.EMPLOYEENUMBER)
Search This Blog
Code snippets and memory joggers
Wednesday, September 22, 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
About Me
- Keith
- I love to travel and meet new people, motorbikes, moving my body through dance, martial arts and yoga. I'm a lifelong learner interested in how things work, and the way people think and make their decisions. My choice of superpower would be to speak with someone and understand them completely, including their intention and for me to be able to communicate my intention to them clearly in their own language. As an Amazon Associate, I may earn from links to qualifying purchases.
No comments:
Post a Comment