SELECT * FROM TABLEB WHERE (ID,STARTDATE,ENDDATE) IN
(SELECT DISTINCT(ID,STARTDATE,ENDDATE) FROM TABLEB
WHERE UPDATED_DATE>SELECT MAX(UPDATED_DATE) FROM TABLEA)
What is the problem with this query. The inner query is returning me data. The value
for ENDDATE is null in the table. However when executing the complete query its returing
me zero results.How do we solve it .