Hi, i have 3 tables in oracle sql developer (packing, detail, header). I need to update the packing table's part no with header table's part no. But header doesn't contain the serial id hence i need to refer to detail table for cross reference. I did like below, but it throws an error. Please help to give an idea.
update packing set packing.no = header.no where (packing.id like 'R%' and packing.no = 'N' and packing.id = detail.id and packing.box = header.box and header.box = detail.box)