Exact Online query of the day January 29, 2016

exact-online-query-of-the-day-january-29-2016

Give me a list of articles sold and maybe shipped, including account, amount, item and quantities.

select act.classification
,      tle.accountname
,      act.postcode
,      act.city
,      act.country
,      tle.itemdescription
,      tle.quantity
,      tle.amountdc
,      tle.financialperiod
,      sie.invoicedate
,      tle.accountcode
,      tle.itemcode
from   TransactionLines tle
join   salesinvoices sie
on     sie.invoicenumber = tle.invoicenumber
join   accounts act
on     act.id = tle.account
where  tle.item is not null