>>>SELECT * FROM mytable where; >>> f1 in (SELECT f1 from look_up group by f1 having count(*) = 1) AND ; >>> f2 in (select f2 from look_up group by f2 having count(*) = 1) >>>>>>
>>>update mytable set flag = "1" where; >>> f1 in (SELECT f1 from look_up group by f1 having count(*) = 1) AND ; >>> f2 in (select f2 from look_up group by f2 having count(*) = 1) >>>>>
>>update mytable set flag = "1"; >>FROM mytable; >> where f1 in (SELECT f1 from look_up group by f1 having count(*) = 1) AND ; >> f2 in (select f2 from look_up group by f2 having count(*) = 1) >>>
update mytable set flag = "1"; FROM mytable; INNER JOIN (SELECT f1 from look_up group by f1 having count(*) = 1) Tbl1 ON MyTable.F1 = Tbl1.F1 INNER JOIN (SELECT f2 from look_up group by f2 having count(*) = 1) Tbl2 ON MyTable.F2 = Tbl1.F2