using UPDATE with GROUP By

[Bart Pietercil]

Hm,

suspecting a flaw in your logic; can you describe me what you want to do (limited to the tables we're looking at).
I have to leave now but I'll try to look at the db and your explanation this evening late or maybe tomorrow


Bart Pietercil
CTO Cognosis NV



On 20 Jun 2010, at 17:22, william humphrey wrote:

> Same thing with this:
> 
> UPDATE data_address SET d_address_LineNumber = 1 WHERE
> d_address_LineNumber IN (select d_address_LineNumber from
> (select d_address_LineNumber, d_address_clients_ref, count
> (d_address_clients_ref) as SomeName
> from data_address
> group by d_address_LineNumber,d_address_clients_ref
> having SomeName = 1)
> )
> 
> All 8150 rows are affected an set to 1. GEEZ!
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina