Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT o.status, COUNT(*) AS COUNT FROM orders o JOIN branch b ON o.brid=b.br_id AND b.`code`='NY' WHERE o.created_ON >=DATE_SUB(CURDATE(),INTERVAL 90 DAY) GROUP BY o.`status`;
OR o.shop_num IN (SELECT s.shop_no FROM shops s, branches b WHERE s.branch_id=b.branch_id AND b.branch_code='NY')
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!