[AccessD] mysql query dosen't filter on HAVING

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


Solved.... I was just blind...
I missed the WHERE!!!!

Sorry
Thank's
/kostas


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kostas Konstantinidis
Sent: Tuesday, May 3, 2016 10:02 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] mysql query dosen't filter on HAVING

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



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list