I want to retrieve all sales data for a particular fiscal wk. e.g wk 1 ; I have a calendar table (tbl_calander) like one in the image.
How to join this table with sales table(tbl_sales.date). If I join using date column, it is returning duplicate rows as there are many sales in one single day.
Any help would be greatly appreciated.