I am getting an error message whenever I try executing a SQL query while creating a grid. I'm using the SQL Genie and have manually created my SQL statement, whenever I click the Execute Query button the query will return the records then the attached error message will pop up. Does anyone know what this means or how to fix it? I've attached a screen capture of the error dialog and have also put the SQL statement below. I'm using MySQL, if that matters.
Capture.PNG
SELECT
Patient.*,
Referral.Name as RefName,
Provider.Doc as Doc,
Concat(TRIM(Provider.Name), ', ', TRIM(Provider.FirstName)) AS Provider,
TRIM(Facility.Name) As Facility,
Carrier1.CorpName AS Ins1Name,
Carrier1.Mnem AS Ins1Mnem,
Policy1.InsId AS Ins1Policy,
Policy1.InsGroup AS Ins1Group,
SUM(Service.PtNt) As Ptnt,
SUM(Service.Amount-Service.Applied) AS BalanceDue,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Title1 AND Listdata.Listnameid = 50) As PatientTitle,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Stat AND Listdata.Listnameid = 51) As PatientStat,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Student AND Listdata.Listnameid = 52) As PatientStudent,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Employed AND Listdata.Listnameid = 54) As PatientEmployed,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Race AND Listdata.Listnameid = 49) As PatientRace,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category1 AND Listdata.Listnameid = 47) As PatientCat1,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category2 AND Listdata.Listnameid = 47) As PatientCat2,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category3 AND Listdata.Listnameid = 47) As PatientCat3,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category4 AND Listdata.Listnameid = 47) As PatientCat4
FROM IdentFil As Patient
LEFT JOIN Ref AS Referral ON Patient.RefNum = Referral.RefNum
LEFT JOIN DocIdent AS Provider ON Provider.Id = Patient.DocId
LEFT JOIN DocIdent AS Facility ON Patient.FacilityId = Facility .Id
LEFT JOIN PatIns AS Policy1 ON Patient.PtNum = Policy1.PtNum AND Policy1.InsOrder=1 AND Policy1.IsActive=1
LEFT JOIN InsIdent AS Carrier1 ON Policy1.InsNum = Carrier1.InsNum
LEFT JOIN PostFile AS Service ON Patient.PtNum = Service.PtNum AND Service.Typ='C'
GROUP BY Patient.PtNum
Capture.PNG
SELECT
Patient.*,
Referral.Name as RefName,
Provider.Doc as Doc,
Concat(TRIM(Provider.Name), ', ', TRIM(Provider.FirstName)) AS Provider,
TRIM(Facility.Name) As Facility,
Carrier1.CorpName AS Ins1Name,
Carrier1.Mnem AS Ins1Mnem,
Policy1.InsId AS Ins1Policy,
Policy1.InsGroup AS Ins1Group,
SUM(Service.PtNt) As Ptnt,
SUM(Service.Amount-Service.Applied) AS BalanceDue,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Title1 AND Listdata.Listnameid = 50) As PatientTitle,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Stat AND Listdata.Listnameid = 51) As PatientStat,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Student AND Listdata.Listnameid = 52) As PatientStudent,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Employed AND Listdata.Listnameid = 54) As PatientEmployed,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Race AND Listdata.Listnameid = 49) As PatientRace,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category1 AND Listdata.Listnameid = 47) As PatientCat1,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category2 AND Listdata.Listnameid = 47) As PatientCat2,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category3 AND Listdata.Listnameid = 47) As PatientCat3,
(SELECT ListText FROM ListData WHERE ListValue = Patient.Category4 AND Listdata.Listnameid = 47) As PatientCat4
FROM IdentFil As Patient
LEFT JOIN Ref AS Referral ON Patient.RefNum = Referral.RefNum
LEFT JOIN DocIdent AS Provider ON Provider.Id = Patient.DocId
LEFT JOIN DocIdent AS Facility ON Patient.FacilityId = Facility .Id
LEFT JOIN PatIns AS Policy1 ON Patient.PtNum = Policy1.PtNum AND Policy1.InsOrder=1 AND Policy1.IsActive=1
LEFT JOIN InsIdent AS Carrier1 ON Policy1.InsNum = Carrier1.InsNum
LEFT JOIN PostFile AS Service ON Patient.PtNum = Service.PtNum AND Service.Typ='C'
GROUP BY Patient.PtNum
Comment