Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT fu.fuszernev
- FROM Fuszer AS fu
- WHERE fu.fkod IN (
- (SELECT * FROM
- (SELECT fkod FROM
- (SELECT mediterran.fkod AS fkod FROM
- (SELECT Fuszer.fkod
- FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
- WHERE (((Keverek.kevereknev)="Grill"))) flekken
- RIGHT OUTER JOIN
- (SELECT Fuszer.fkod
- FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
- WHERE (((Keverek.kevereknev)="Pikáns Grill"))) mediterran ON flekken.fkod = mediterran.fkod
- WHERE flekken.fkod IS NULL
- )
- UNION
- (SELECT flekken.fkod AS fkod FROM
- (SELECT Fuszer.fkod
- FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
- WHERE (((Keverek.kevereknev)="Grill"))) flekken
- LEFT OUTER JOIN
- (SELECT Fuszer.fkod
- FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
- WHERE (((Keverek.kevereknev)="Pikáns Grill"))) mediterran ON flekken.fkod = mediterran.fkod
- WHERE mediterran.fkod IS NULL
- )
- )
- )
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement