[AccessD] mysql query dosen't filter on HAVING

Kostas Konstantinidis kost36 at otenet.gr
Tue May 3 14:01:45 CDT 2016


Hi group
I use a mysql query like

VIEW `2nd_movie` AS
    SELECT DISTINCT
        `ST_peoplefilms`.`ID_films` AS `ID_films`,
        `ST_peoplefilms`.`ID_idiotita` AS `ID_idiotita`,
        `MT_films`.`Title1` AS `Title1`,
        `MT_films`.`room_last` AS `room_last`,
        `MT_films`.`etos` AS `etos`,
        `MT_films`.`katigoria` AS `katigoria`,
        `MT_films`.`diarkeia` AS `diarkeia`,
        `MT_films`.`proeleysiSenarioy` AS `proeleysiSenarioy`,
        GROUP_CONCAT(DISTINCT `T_people`.`person`
            ORDER BY `T_people`.`person` ASC
            SEPARATOR ', ') AS `person`,
        CONCAT_WS(' - ',
                `MT_films`.`Title1`,
                `MT_films`.`Title2`,
                `MT_films`.`Title3`,
                `MT_films`.`title4`) AS `Titles`
    FROM
        ((`MT_films`
        JOIN `ST_peoplefilms` ON ((`MT_films`.`ID_films` =
`ST_peoplefilms`.`ID_films`)))
        LEFT JOIN `T_people` ON ((`T_people`.`ID_person` =
`ST_peoplefilms`.`ID_person`)))
    GROUP BY `ST_peoplefilms`.`ID_films`
    HAVING ((`ST_peoplefilms`.`ID_idiotita` = 29)
        AND (`MT_films`.`room_last` = 3))

But it doesn't filter on ID_idiotita=29 which is related to Director(s) of
the movie 
It returns all the other crew values as well

Am I missing something in that?
Thank's
/kostas





More information about the AccessD mailing list