Thanks appunair. I've tried what you've suggested but luck so far. Here is the current SQL:-
select dtree.dataid as "Unique ID",k.valstr as "Sort Code", c.valstr as "Account Number", f.valstr as "Customer Number", h.valstr as "Document Type", l.valstr as "Transaction Type", b.valstr as "Date...