I have two tables, one with the month numbers and one with the stores. I want to create a third table with two columns with adding a inputfield to put the number of sales. Is it possible?
First join the tables, then create a new table with a resident load and add the input field:
LOAD * FROM ...table1...;
LOAD * FROM ...table2...;
LOAD *, 0 as NoOfSales RESIDENT Temp;
DROP TABLE Temp;
Thank you for the precise answer.
Is it a real problem if joining tables creates a circular join?
Retrieving data ...