error -1103, too complicated SQL statement

[Sven Köhler]

I'm very irritated that SAPDB tells me, that my query is too complicated.

SELECT a.id_artikel,a.datum,b.lvb,a.titel,a.anreisser
FROM pa_data_artikel a
LEFT JOIN base_landesverbände b on (a.id_lvb=b.id_lvb)
WHERE lower(anreisser) LIKE '%a%'
OR lower(titel) LIKE '%a%'
OR lower(pressekontakt) LIKE '%a%'
OR lower(email) LIKE '%a%'
OR EXISTS (SELECT * FROM pa_data_artikel_text1 c WHERE c.id_artikel=a.id_artikel AND lower(text) LIKE '%a%')
OR EXISTS (SELECT * FROM pa_data_artikel_text2 c WHERE c.id_artikel=a.id_artikel AND lower(text) LIKE '%a%')
ORDER BY a.datum desc

i don't think that this is that complicated, so what may be the cause of that "error"?

Thx
Sven


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general