fp_sQry="
SELECT tableB.*,
(Select Sum(AntlAh) FROM tableB) AS [TTAntlAh],
tableA.Fname, tableA.Lname, tableA.mailadress, tableA.GSM
FROM tableB
LEFT JOIN tableA ON tableB.LnameAh=tableA.Lname
ORDER by Ah-Id ASC"
=> gives this error :
Database Results Error - Description: No value given for one or more required parameters.
=> without <ORDER BY Ah-Id ASC> or <ORDER BY ... DESC> it works fine.
Possible causes : wrong combination JOIN vs ORDER BY ? elements not in the correct order in the query ?
Thanks for tips - Leifoet
SELECT tableB.*,
(Select Sum(AntlAh) FROM tableB) AS [TTAntlAh],
tableA.Fname, tableA.Lname, tableA.mailadress, tableA.GSM
FROM tableB
LEFT JOIN tableA ON tableB.LnameAh=tableA.Lname
ORDER by Ah-Id ASC"
=> gives this error :
Database Results Error - Description: No value given for one or more required parameters.
=> without <ORDER BY Ah-Id ASC> or <ORDER BY ... DESC> it works fine.
Possible causes : wrong combination JOIN vs ORDER BY ? elements not in the correct order in the query ?
Thanks for tips - Leifoet