How to do an outer join in Tadabase

I want to merge 2 tables. 1 is a user table and the other is a time entries table.
Some users don’t have a corresponding time entry on that particular day.
Those are the users I would like to send automatically an email, with the Automation, for that I would like to populate a temporary table, which will be emptied for the next day.

Could someone advice how to do that, or is the outside alternative to use?

this can be deleted. I made it differently. I use make now to make time sheets per day in advance for all users marked for time sheeting. It is faster and circumvents this problem.