Topic: WHATS WRONG! CAN NOT DISPLAY VALUES
i have two tables STCL & STCL_Board as follows
[STCL]
isdictionary=0
>id_STCL_BOARD=STCL_BOARD
_NAMERTN=TEXT
_STCL_NXTDD=DATE
[STCL_BOARD]
isdictionary=0
_BOARD=TEXT
_REMARKS=TEXT
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.
pls. help