JOIN and INTO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT CPASS_SCA.SCA_AC_ID,
[CPASS_PL].[SOURCE_AC_DESC]
INTO SCA_LDG
FROM CPASS_PL
LEFT JOIN CPASS_SCA ON
[CPASS_PL].[SOURCE_AC_DESC]=[CPASS_SCA].[SOURCE_AC_DESC]

With the above I am simply trying to create a new table (SCA_LDG) that
contains data from the main table (CPASS_PL)with data from the left joined
data (CPASS_SCA).

Then only complication, if you can describe it as such, is that the join is
on a common data element (SOURCE_AC_DESC) which is not required in the target
(SCA_LDG).

The problem I am having is that when I run the query an 'Enter Parameter
Sreen' pops up for the SCA_AC_ID value. This happens instead of it simply
popualting the target table with the SCA_AC_ID values contained in the
CPASS_SCA.

This query woks perfectly well in MS_SQLSERVER (which the client does not
use) and is identical the one shown in the Access Helpfor JET SQL JET SQL.

Any ideas??

Cheers

Coburndavis
 
COBURNDAVIS said:
SELECT CPASS_SCA.SCA_AC_ID,
[CPASS_PL].[SOURCE_AC_DESC]
INTO SCA_LDG
FROM CPASS_PL
LEFT JOIN CPASS_SCA ON
[CPASS_PL].[SOURCE_AC_DESC]=[CPASS_SCA].[SOURCE_AC_DESC]

With the above I am simply trying to create a new table (SCA_LDG) that
contains data from the main table (CPASS_PL)with data from the left joined
data (CPASS_SCA).

Then only complication, if you can describe it as such, is that the join is
on a common data element (SOURCE_AC_DESC) which is not required in the target
(SCA_LDG).

The problem I am having is that when I run the query an 'Enter Parameter
Sreen' pops up for the SCA_AC_ID value. This happens instead of it simply
popualting the target table with the SCA_AC_ID values contained in the
CPASS_SCA.

This query woks perfectly well in MS_SQLSERVER (which the client does not
use) and is identical the one shown in the Access Helpfor JET SQL JET SQL.
Click to expand...


I don't know if I can help beyond saying that a parameter
prompt clearly indicates that whatever you are being
prompted for does not exist in the table. Doublecheck the
spelling and pay careful attention to any funny characters
such as spaces or other punction characters.
 
Back
Top