This content has been marked as final. Show 2 replies
I believe I have a very simple problem.
I have got two tables and want to calculate sth. with one field of each of them. They are connected by the ID.
Now I want to subtract Days-DaysOff as a new field in Table1.
So I started like this:
left join (Table1) LOAD ID, Days-DaysOff as TotalDays resident Table2;
I also switched Table1 and Table2 but I dont get it. TotalDays should be a field of Table1. In the best case I do not want to JOIN them. I know this would be a solution.
Thanks in advance!