SQL View

CREATE
    ALGORITHM = UNDEFINED
    DEFINER = `root`@`%`
    SQL SECURITY DEFINER
VIEW `s1` AS
    SELECT
        `a`.`artikelname` AS `Artikel`,
        `h`.`herstellername` AS `Herstller`
    FROM
        (`artikel` `a`
        LEFT JOIN `hersteller` `h` ON (`a`.`herstellernummer` = `h`.`herstellernummer`))
    WHERE
        `h`.`herstellername` = 'Logitech'