I am trying to execute a query in a MySQL node, and when I paste my query into the query box it won’t save it.
At first I thought that it was because I was using a common table expression, but I restructured the query to carry out a join on a subquery, and that still doesn’t work (see query below)
When I paste it into the query box and then close the box, it won’t save it. Is there a parser that is objecting to the query I’m pasting in. The query works in my normal query editor.
e.Fullname as AssessorName,
d.Fullname as ValidatorName,
inner join ( select distinct
(ContractSurveyID) as ContractSurveyID
ContractSurveyID in( select distinct
from ContractSurvey cs
right join (
ContractSurveyID, Sort, SourceContractSurveySectionID, count()
count() > 1) as css on cs.ContractSurveyID = css.ContractSurveyID
ParentContractSurveyID is null)) as b on a.ContractSurveyID = b.ContractSurveyID
left join SurveyStatus as c on a.SurveyStatusID = c.SurveyStatusID
left join VinylSharedData.User as d on a.OwnerID = d.UserID
left join VinylSharedData.User as e on a.FRAAssessorID = e.simPROID;