Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- DATE_FORMAT(o.DATE_INSERT,'%Y-%m-%d') as DATE,
- COUNT(*) as CNT
- from
- b_sale_order o
- left join b_sale_basket b on b.ORDER_ID = o.ID
- where 1=1
- and b.ID is NULL
- group by DATE
- order by DATE DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement