I would like to get all my customers W1A0 data ( only one row per customer that must be the max timestampo_updated ), all my customers W1V0 data and the W1L0 data that as the max TIMESTAMP-UPDATED from customer that matches the W1A0 customer.
with t1 (client_reference,max_update) as
group by client_reference)
inner join w1a0 as a on (t1.client_reference = a.client_reference and t1.max_update = a.timestamp_updated)
inner join w1v0 as b on (t1.client_reference = b.client_reference)
inner join w1l0 as c on (t1.client_reference = c.client_reference and t1.max_update = c.timestamp_updated)