vp wrote:
PK1 STATE1 PROV1 PLAN1
pk2 state2 prov2 plan2
If (STATE1=state2 and PROV1=prov2 ) than take pk2 to plug in to
another field
Should I do a self join on the table to check this condition??? or
please advice
thanks,
As Joe Celko often says, some DDL would help, but here's a guess based
on my best guess based on what little data I have.
Perhaps you want something like:
UPDATE some_other_table SET some_column=(
SELECT pk FROM first_table
WHERE state='state2'
AND province='prov2')