the into statement in a query

J

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
 
P

pietlinden

JJ said:
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
Click to expand...

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

JJ

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

[email protected] said:
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
Click to expand...

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