Hello,
I execute the below pictured SQL-Statement and became the error:
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-710 Missing SELECT PARSID.
If I change the order of the SELECTs in the SQL-Statemant (first the
2nd, than the 1st and at last the 3rd) it runs without an error.
The installaled Verions are:
odbc7.4.03
sapdb-all-win-32bit-i386-7_4_3_17
********** schnipp **********
SELECT hasarch.id
FROM hasarch, hasarchfullsize
WHERE hasarch.id = hasarchfullsize.id
AND hasarch.buchungsart = 'printable'
AND hasarch.datum < '2003-08-01'
AND (hasarch.anzeigenstatus = 'SENDED' or hasarch.anzeigenstatus
= 'DEMO')
UNION
SELECT hasarch.id
FROM hasarch, hasarchfullsize, hasarchdate
WHERE hasarch.id = hasarchfullsize.id
AND hasarch.id = hasarchdate.id
AND hasarch.buchungsart = 'ad'
AND hasarchdate.datum = (SELECT max(datum)
FROM hasarchdate d
WHERE d.id = hasarch.id)
AND hasarchdate.datum < '2003-08-01'
AND (hasarch.anzeigenstatus = 'SENDED' or hasarch.anzeigenstatus
= 'DEMO')
UNION
SELECT hasarch.id
FROM hasarch, hasarchfullsize
WHERE hasarch.id = hasarchfullsize.id
AND hasarch.datum < '2003-08-01'
AND hasarch.anzeigenstatus = 'SAVED'
ORDER BY 1
********** schnapp **********
Can anybody tell me, what wrong?
Greetings
Matthias
.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
