i have a "problem" and wanted to know if there is an alternative to what i thought of. I couldn't find any "solution" for my topic so i'm creating this subject.
The reason why is that table1 is pretty huge and i wanted to reduce the work load and only want to load the data i really need.
I have 2 tables and 1 resulting table.
table1: is for production values for each sort and each date
table2: is for each sort and its start production date
table3: is the resulting table i want to have
You may wonder why there are production values (table1) for Chocolate while the start date (table2) is later.
This is due to a change in the department and also the reason for this subject
So my actual question is: Is there a possibility to load the data in (table1) based on the productionstartdate (table2) without joining those tables?
