hello,
the following problem: i have query with this having clause:
FROM
lt_em_reihe AS r
INNER JOIN lt_em_schein AS s ON s.id=r.schein_id
INNER JOIN lt_gruppen AS gr ON gr.id = s.gruppe_id
INNER JOIN lt_gueltigkeit ON lt_gueltigkeit.id=gr.gueltigkeit_id
INNER JOIN lt_emquoten AS a ON a.datum BETWEEN lt_gueltigkeit.start AND lt_gueltigkeit.ende
INNER JOIN artikelgruppe ON gr.produkt_id=artikelgruppe.id
WHERE
artikelgruppe.bez ='game'
HAVING
((TREFFERZ >"0") AND (TREFFERS = "2"))OR
((TREFFERZ ="2") AND (TREFFERS > "0"))
OR (TREFFERZ >"2")
in the result tab i see the correct result. but when i build the pages i get an error 256. with the message, the there is a syntax problem near having.
when i make the same query without having clause i get no error. what is the problem. the syntax could not be the problem. i see the problem in phpr.
is there any solution??
