php Programming Glossary: c.date
Dynamically creating date periods using MySQL http://stackoverflow.com/questions/9552508/dynamically-creating-date-periods-using-mysql I see you're still looking for a solution. Try this select c.date f.fruitName count f.fruitName 'Grapes' from tbl_calendar c left.. 'Grapes' from tbl_calendar c left join tbl_fruits f on c.date f.fruitDate and f.fruitName 'Grapes' group by c.date f.fruitName.. f on c.date f.fruitDate and f.fruitName 'Grapes' group by c.date f.fruitName If you also want to filter the extra dates from..
|
