Customer list
Company column has hint containing company orders
{{COMPANY}}
{{ADDR1}}, {{CITY}}, {{STATE}}
{{CONTACT}} ({{PHONE}})
select c.* from customer c
{{{header}}}{{{body}}}
]]>
{{{_text}}}
]]>
select o.orderno, cast(saledate as date) saledate, cast(shipdate as date) shipdate,
paymentmethod, itemstotal, amountpaid, e.lastname
from orders o
join employee e on e.empno=o.empno
where custno=:custno
order by 1