Hi!

select * from table customer
left join table copyto on copyto.id=:copyto
left join table secondcopy on secondcopy.id=:secondcopy

How can all fields be accessed via FieldByName?

FieldByName('copyto.name') or FieldByName('secondcopy.name') won't
work...

Regards, Boris