On 10/16/2015 3:23 PM, Don V Nielsen wrote: > limit ( > SELECT net_non_pieces > FROM crrt_net_non [b] > WHERE [b].zip = zip AND [b].crrt = crrt
Again, I don't think this does what you think it does. Test with at least two rows in crrt_net_non, with different values for net_non_pieces, and confirm that as many rows are being updated as you've hoped. I suspect you may be disappointed. -- Igor Tandetnik