Hello,
We hope to make a complete workflow based on SQL, but the method I can think of at present can only run the step of' create table previous _ results' separately.
Is there any way to merge them together?
The SQL likes:
CREATE TABLE tbl_Previous_Results
AS SELECT * FROM tbl_Current_Results
SELECT column_a, column_b, column_c
INTO tbI_Current_Results
FROM [database]
SELECT tbl_Current_Results.a, tbl_Current_Results.b, tbl_Previous_Results.c
INTO tb_c
FROM tbI_Current_Results
LEFT JOIN tbl_Previous_Results
ON tbl_Current_Results.b = tbl_Previous_Results.b
The workflow now:
Really appreciate!
Solved! Go to Solution.
Hi @KKWang
I would suggest using the Block Until Done Tool to first write the previous file ensure that the file has been written prior to trying to re-open it later in the workflow.
Thanks,
Wes
Thanks @WesCannon , the answer is really useful.