select f1,f2 group by f1,f2 into cursor look_upthen if I do following select, I get a result ok:
SELECT id 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)so I'd expect to be able to do:
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)but that gives a sql expression to complex error, I'd expect a simple update like that to work whereever the select works, even if I do the two group selects beforehand so that the two selects in the IN bits are simple it fails, so are the limits really different and if so where can I check out the differences?
update mytable set flag = "1" where id in (select id from complexselect)Just curious as I wasted 10 mins looking inquizitivly at the two statements.