using UPDATE with GROUP By

[Bart Pietercil]

Hi William,
downloaded b_I_database.vdb.zip but no data (off course). Without data there is not much I can look at...


Bart Pietercil
CTO Cognosis NV



On 20 Jun 2010, at 17:54, Bart Pietercil wrote:

> 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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina