hello,
i need your help.
I would like to return data of previous month for field imonumber where no entries exists - that way use can see which imonumber have not data of previous month .
so i have beloq mysql query which only shows data of previous month but is not what i need - i need imonumber with NO data for previous month
SELECT
csvimport.ID,
csvimport.IMONUMBER,
csvimport.VESSELNAME,
MONTHNAME(STR_TO_DATE(
date,'%d/%m/%Y')) AS MonthName,
YEAR(STR_TO_DATE(
date,'%d/%m/%Y')) AS YearName,
MONTH(STR_TO_DATE(
date,'%d/%m/%Y')) AS MONTHO,
csvimport.
DATE,
MAX(DATE(STR_TO_DATE(
date,'%d/%m/%Y'))) AS DateName,
user_tab.user_id
FROM csvimport
INNER JOIN vessel_tab ON csvimport.IMONUMBER = vessel_tab.imo
INNER JOIN user_company_tab ON vessel_tab.company_id = user_company_tab.company_id
INNER JOIN user_tab ON user_company_tab.user_id = user_tab.user_id
WHERE (YEAR(STR_TO_DATE(
date,'%d/%m/%Y')) =YEAR(CURDATE())) AND (MONTH(STR_TO_DATE(
date,'%d/%m/%Y')) =MONTH(CURRENT_DATE - INTERVAL 1 MONTH))
GROUP BY csvimport.IMONUMBER, MONTH(STR_TO_DATE(
date,'%d/%m/%Y'))
ORDER BY YEAR(STR_TO_DATE(
date,'%d/%m/%Y')) DESC, MONTH(STR_TO_DATE(
date,'%d/%m/%Y'))
\