Re: [GENERAL] updating dup row

2017-02-16 Thread John R Pierce
On 2/16/2017 6:25 PM, Patrick B wrote: how can I update a row with newest id from another table if it exists somewhere else? Example: *table test1* * id (primary key) * id_user_bill * clientid *table test2* * item_id * userid (there are duplicated rows here) * clientid * id (p

[GENERAL] updating dup row

2017-02-16 Thread Patrick B
Hi all, how can I update a row with newest id from another table if it exists somewhere else? Example: *table test1* - id (primary key) - id_user_bill - clientid *table test2* - item_id - userid (there are duplicated rows here) - clientid - id (primary key) -- finding th