[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: This is not trivia pursuit....

Try the following

update ps_employment a
set a.business_title = (select b.jobtitle from ps_employees b
                                where a.emplid = b.emplid)
where exists (select 'X' from ps_employees b
                                where a.emplid = b.emplid);


Carlton