ExecuteSQLit sql=
insert into tmpa (select distinct SecondaryIssueId,' ',' ' ,concat(substring(DateNeeded,1,10),SUBSTRING(IssueTitle,1,20)),' ',' ',' ',' ',' ',' ' from RelatedIssues,Issues where Issues.IssueId=RelatedIssues.SecondaryIssueId and RelationType=0 and PrimaryIssueId=)
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
|