I need to create a time log report from where we can get the time log report but i am running the SQL query and used the joins properly but it's not showing the null data.

is there a bug in Zoho analytics regarding joins?