I have four tables and need to create new fields from those tables. For example Field C should be calculated from table 1,2,3.
I did it over left joins but then it is too slow. What would be the best option to create those fields?
My final goal is to create new QVD where all data would be stored(from all 4 tables)?