Re: Lookup multiple tables

[Peter Brawley]

Is this what you mean?

update expenditure e
join   card        c on e.cardnumber=c.cardnumber
join   owner       o on c.id_card=o.id_card
join   person      p on p.id_person=o.id_person
set e.name=p.name
where e.name<>p.name;