kiss.shoremishra
Registered User.
- Local time
- Today, 08:03
- Joined
- Feb 4, 2017
- Messages
- 19
Hi All,
I am trying to move a table to another database by modify the below query
SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number, TPR_ITEM_ATTRIBUTES_CONFIG.LONG_DESCRIPTION AS BMILongDesc, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_DESC AS BMIShortDesc INTO tbl_SMART_BOM_Header_BMI
FROM TPR_BOM_HEADERS_CONFIG INNER JOIN TPR_ITEM_ATTRIBUTES_CONFIG ON TPR_BOM_HEADERS_CONFIG.ASSEMBLY_ITEM_ID = TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_ID
WHERE (((TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_TYPE)="BMI") AND ((TPR_BOM_HEADERS_CONFIG.SMI_BOM_TYPE)="SMI") AND ((TPR_BOM_HEADERS_CONFIG.BOM_PARTITION_KEY)=0));
to below mentioned query by including the URL of new database
SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number, TPR_ITEM_ATTRIBUTES_CONFIG.LONG_DESCRIPTION AS BMILongDesc, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_DESC AS BMIShortDesc INTO tbl_SMART_BOM_Header_BMI IN '\\perseco.com
\files\groups\SCDM\PROD\SMART\DATABASES\SMART_MIR_Extended.accdb' FROM TPR_BOM_HEADERS_CONFIG INNER JOIN TPR_ITEM_ATTRIBUTES_CONFIG ON TPR_BOM_HEADERS_CONFIG.ASSEMBLY_ITEM_ID = TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_ID
WHERE (((TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_TYPE)="BMI") AND ((TPR_BOM_HEADERS_CONFIG.SMI_BOM_TYPE)="SMI") AND ((TPR_BOM_HEADERS_CONFIG.BOM_PARTITION_KEY)=0));
But I am getting the Invalid Bracketing error and I am not sure why as all my parenthesis, brackets and single quotes are properly closed. Please advise ASAP.
Historically I never got such error whenever I tried to move tables created using Make Table query.
I am trying to move a table to another database by modify the below query
SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number, TPR_ITEM_ATTRIBUTES_CONFIG.LONG_DESCRIPTION AS BMILongDesc, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_DESC AS BMIShortDesc INTO tbl_SMART_BOM_Header_BMI
FROM TPR_BOM_HEADERS_CONFIG INNER JOIN TPR_ITEM_ATTRIBUTES_CONFIG ON TPR_BOM_HEADERS_CONFIG.ASSEMBLY_ITEM_ID = TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_ID
WHERE (((TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_TYPE)="BMI") AND ((TPR_BOM_HEADERS_CONFIG.SMI_BOM_TYPE)="SMI") AND ((TPR_BOM_HEADERS_CONFIG.BOM_PARTITION_KEY)=0));
to below mentioned query by including the URL of new database
SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number, TPR_ITEM_ATTRIBUTES_CONFIG.LONG_DESCRIPTION AS BMILongDesc, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_DESC AS BMIShortDesc INTO tbl_SMART_BOM_Header_BMI IN '\\perseco.com
\files\groups\SCDM\PROD\SMART\DATABASES\SMART_MIR_Extended.accdb' FROM TPR_BOM_HEADERS_CONFIG INNER JOIN TPR_ITEM_ATTRIBUTES_CONFIG ON TPR_BOM_HEADERS_CONFIG.ASSEMBLY_ITEM_ID = TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_ID
WHERE (((TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_TYPE)="BMI") AND ((TPR_BOM_HEADERS_CONFIG.SMI_BOM_TYPE)="SMI") AND ((TPR_BOM_HEADERS_CONFIG.BOM_PARTITION_KEY)=0));
But I am getting the Invalid Bracketing error and I am not sure why as all my parenthesis, brackets and single quotes are properly closed. Please advise ASAP.
Historically I never got such error whenever I tried to move tables created using Make Table query.
Last edited: