While running the below JOIN query, I am not able to get the data. There is actually 1 record available with `updatedAt` date = 2020-06-30 ( please see screen shot )

I would like to create a JOIN query to display data for `createdAt or updatedAt` date = CURDATE()

Below query is returning no records, please see the screenshot:

[![enter image description here](https://i.stack.imgur.com/WbnUs.png)](https://i.stack.imgur.com/WbnUs.png)

```
SELECT user.id, user.photo, user.position, availability.dailystatus 
FROM user  
join availability  
ON user.id = availability.id where (SELECT DATE((availability.createdAt) or (availability.updatedAt))) = CURDATE();

```

[![enter image description here](https://i.stack.imgur.com/bwxae.png)](https://i.stack.imgur.com/bwxae.png)