If I remove DESC
it uses this statement with no error?? Why not object to that SUBMITDATE
token in that position?
SELECT ID, F_PADLEFT(LINKTOMEMBER,'0',6) LINKTOMEMBER, JOBTITLE,
SHORTDESCRIPTION, SUBMITDATE, EMPTIME, EMPSTATUS, ADREF,
(SELECT TITLE FROM LOCATION WHERE ADVERTISEMENTS.LINKTOLOCATION=LOCATION.ID)
AS LOCATION,
(SELECT TITLE FROM ROLECATEGORIES WHERE
ADVERTISEMENTS.LINKTOROLECATEGORY=ROLECATEGORIES.ID) AS CATROLE,
(SELECT ADTEMPLATE FROM MEMBERS WHERE
ADVERTISEMENTS.LINKTOMEMBER=MEMBERS.MEMNO) AS ADTEMPLATE,
(SELECT USECUSTOM FROM MEMBERS WHERE
ADVERTISEMENTS.LINKTOMEMBER=MEMBERS.MEMNO) AS USECUSTOM,
f_dayofmonth(SUBMITDATE)||'.'||f_month(SUBMITDATE)||'.'||f_year(SUBMITDATE)
MYSUBMITDATE
FROM ADVERTISEMENTS
SUBMITDATE
WHERE (
(
(
(ADVERTISEMENTS.ADACTIVE = -1)
AND (ADVERTISEMENTS.EXPIRY > 'NOW')
AND LINKTOLOCATION IN (3)
)
AND LINKTOROLECATEGORY IN (1)
)
AND EMPTIME = 'part-time'
)
AND EMPSTATUS = 'contract'