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,