Advertisement
wzline

Distribution empty orders on date

Feb 21st, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. select
  2.     DATE_FORMAT(o.DATE_INSERT,'%Y-%m-%d') as DATE,
  3.     COUNT(*) as CNT
  4. from
  5.    b_sale_order o
  6.    left join b_sale_basket b on b.ORDER_ID = o.ID
  7. where 1=1
  8.    and b.ID is NULL
  9. group by DATE
  10. order by DATE DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement