pp89
asked on
PLSQL Question
I want do an update on a column(lines table) but the data to be updated exists in two other tables
update lines set a=(select b||'-'||c from hdr, lines where hdr.id=line.id and a is null) where a is null but how to join lines with this select statement,
Thanks
update lines set a=(select b||'-'||c from hdr, lines where hdr.id=line.id and a is null) where a is null but how to join lines with this select statement,
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.