According to Thomas Good:
> This query takes 20 years (poetic licence invoked ;-).
> Do you have a smarter way to accomplish this end:
>
> UPDATE table1 SET id = 2
> WHERE rec_num IN
> ( SELECT rec_num
> FROM table1
> WHERE id = 1
> );
Am I missing something here or is this the same as:
UPDATE table1 SET id = 2 WHERE id = 1;
??
Les Mikesell
les(at)mcs(dot)com