the into statement in a query

[Guest]

The following query gives me an error- Invalid Argument

SELECT john_table.JJ_ID, john_analysis_table.[Circuit ID],
tom_analysis_table.BASELINE_ANNUAL, john_analysis_table.ACTIVATION_DATE
into peter
FROM john_analysis_table INNER JOIN tom_analysis_table ON
john_analysis_table.ATT_ID = tom_analysis_table.ID
ORDER BY john_analysis_table.[Circuit ID];

The problem is with the into statement. When I remove it, the query works
fine.

Thanks for your help.

jj

 

[pietlinden]

The following query gives me an error- Invalid Argument

SELECT john_table.JJ_ID, john_analysis_table.[Circuit ID],
tom_analysis_table.BASELINE_ANNUAL, john_analysis_table.ACTIVATION_DATE
into peter
FROM john_analysis_table INNER JOIN tom_analysis_table ON
john_analysis_table.ATT_ID = tom_analysis_table.ID
ORDER BY john_analysis_table.[Circuit ID];

The problem is with the into statement. When I remove it, the query works
fine.

Thanks for your help.

jj

sounds like either your mapping is wrong or you're violating
referential integrity constraints in the insert.

 

[Guest]

Thank you.

I have not been able locate the error.

Wondering if the code I pasted would help some one to provide me with a
suggestion.

I was able to get the "into" statement to work with a single table
projection query. I seem to be running into this problem when I join tables.
Not sure if this is useful.

Thanks again for your help.

jj

The following query gives me an error- Invalid Argument

SELECT john_table.JJ_ID, john_analysis_table.[Circuit ID],
tom_analysis_table.BASELINE_ANNUAL, john_analysis_table.ACTIVATION_DATE
into peter
FROM john_analysis_table INNER JOIN tom_analysis_table ON
john_analysis_table.ATT_ID = tom_analysis_table.ID
ORDER BY john_analysis_table.[Circuit ID];

The problem is with the into statement. When I remove it, the query works
fine.

Thanks for your help.

jj

sounds like either your mapping is wrong or you're violating
referential integrity constraints in the insert.