Presells

Owned by Richard Mayhew
17-Jul-19
1 min read

This SQL, when run on the Dream Extractor tables will show the presell deposit payments and presell balance payments against an order together with the total balance required.  It's ordered by the most recent transactions.

select * from dbo.sales 
join dbo.sales_payment
on 
dbo.sales.id = dbo.sales_payment.sales_id
where dbo.sales_payment.sales_id in 
(select dbo.sales_payment.sales_id from dbo.sales_payment  
where dbo.sales_payment.payment_method = 'Presell')
order by dbo.sales.id desc;