Please help me understand this query (1 Viewer)

[SachAccess]

Hi,

Could you please help me understand below query.
I am able to run this query without any issues at my desk. I have my own DB for this.
And query is run from another DB.

However another user is facing issues with below query at his machine.
I am not able to understand the reason.
This query is marked with RED cross. I guess this is for Delete.
Am not sure, what exactly will be the impact of this query hence not tried running it manually.
This query is called by a Sub in the DB.
What could be the reason for this query facing issues at user's desk.
FYI, this macro uploads data on SharePoint and user has access to the SharePoint.
Can anyone please help me understand this.

DELETE tblMyChartAnalysis.*, tblMyChartAnalysis.SubProcessName
FROM tblMyChartAnalysis
WHERE (((tblMyChartAnalysis.SubProcessName) In (Select distinct SubProcessName from tblMyMapping)));

 

[CJ_London]

this query will delete all records in tblMyChartAnalysis where the subProcessName exists in tblMyMapping

this part
DELETE tblMyChartAnalysis.*, tblMyChartAnalysis.SubProcessName

only needs to be

DELETE *

with regards why it won't run work for another user. could be many things - tables and/or field names are different or don't exist spring to mind. All depends on what the error message is

don't see anything that uploads the data to sharepoint in what you have provided

 

[isladogs]

I believe this will achieve the same result:

DELETE DISTINCTROW tblMyChartAnalysis.*
FROM tblMyChartAnalysis INNER JOIN tblMyMapping
ON tblMyChartAnalysis.SubProcessName=tblMyMapping.SubProcessName;

The DISTINCTROW is used to ensure unique records. It may not be necessary depending on your tables

 

[SachAccess]

this query will delete all records in tblMyChartAnalysis where the subProcessName exists in tblMyMapping

this part
DELETE tblMyChartAnalysis.*, tblMyChartAnalysis.SubProcessName

only needs to be

DELETE *

with regards why it won't run work for another user. could be many things - tables and/or field names are different or don't exist spring to mind. All depends on what the error message is

don't see anything that uploads the data to sharepoint in what you have provided

Thanks a lot for the help. Really sorry for late reply. Was away due to some emergency.

 

[SachAccess]

I believe this will achieve the same result:

DELETE DISTINCTROW tblMyChartAnalysis.*
FROM tblMyChartAnalysis INNER JOIN tblMyMapping
ON tblMyChartAnalysis.SubProcessName=tblMyMapping.SubProcessName;

The DISTINCTROW is used to ensure unique records. It may not be necessary depending on your tables

Thanks a lot for the help. Really sorry for late reply. Was away due to some emergency.

 

[isladogs]

No problem. Did it work?

 

[SachAccess]

No problem. Did it work?

Hi, was not able to check yesterday. Will share updates with you. Thanks for checking. Have a nice day ahead.