Advertisement
yepp

Untitled

Oct 9th, 2012
329
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.33 KB | None | 0 0
  1. SELECT fu.fuszernev
  2. FROM Fuszer AS fu
  3. WHERE fu.fkod IN (
  4.  
  5.   (SELECT * FROM
  6.  
  7.     (SELECT fkod FROM
  8.  
  9.       (SELECT mediterran.fkod AS fkod FROM
  10.      
  11.         (SELECT Fuszer.fkod
  12.         FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
  13.         WHERE (((Keverek.kevereknev)="Grill"))) flekken
  14.    
  15.       RIGHT OUTER JOIN
  16.    
  17.         (SELECT Fuszer.fkod
  18.         FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
  19.         WHERE (((Keverek.kevereknev)="Pikáns Grill"))) mediterran ON flekken.fkod = mediterran.fkod
  20.    
  21.       WHERE flekken.fkod IS NULL
  22.       )
  23.  
  24.     UNION
  25.  
  26.       (SELECT flekken.fkod AS fkod FROM
  27.      
  28.         (SELECT Fuszer.fkod
  29.         FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
  30.         WHERE (((Keverek.kevereknev)="Grill"))) flekken
  31.      
  32.       LEFT OUTER JOIN
  33.      
  34.         (SELECT Fuszer.fkod
  35.         FROM Keverek INNER JOIN (Fuszer INNER JOIN Komponens ON Fuszer.fkod = Komponens.fkod) ON Keverek.kkod = Komponens.kkod
  36.         WHERE (((Keverek.kevereknev)="Pikáns Grill"))) mediterran ON flekken.fkod = mediterran.fkod
  37.  
  38.       WHERE mediterran.fkod IS NULL
  39.       )
  40.     )
  41.   )
  42. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement