Topic: WHATS WRONG! CAN NOT DISPLAY VALUES
i have two tables STCL & STCL_Board as follows
i made a sql query as follows to get data for the current month as:
SELECT * FROM STCL INNER JOIN STCL_BOARD ON STCL.ID =STCL_BOARD.BOARD WHERE STCL_NXTDD BETWEEN date('now','start of month')AND date('now','start of month','+1 month','-1 day')
when i delete inner join results came out but with inner join it shows nothing with same data
i don't want to use date picker & search option.