Hi, I am having a problem with the following SQL statement (also please see attached designer screenshot).
I have 3 tables: "BL_FILE TO GO", "BL_FILE2", and "BL_FILE"
I am trying to insert records into "BL_FILE2 TO GO" from "BL_FILE2" if BL_FILE2.DELIV_NUM = BL_FILE.DELIV_NUM and BL_FILE.PRINTED)<>0
When I run what I have so far, I get an error "Duplicate Output Destination "DELIV_NUM". There are currently no records in "BL_FILE TO GO".
INSERT INTO [BL_FILE2 TO GO] ( DELIV_NUM )
SELECT BL_FILE2.*, BL_FILE2.DELIV_NUM
FROM BL_FILE2 INNER JOIN bl_file ON BL_FILE2.DELIV_NUM = bl_file.DELIV_NUM