wheri in all

[hotti]

hi,

join mit sich selbst:

  
SELECT  
  
x.a  
  
FROM tab x  
join tab y using(a)  
join tab z using(a)  
where x.b = 1 and y.b = 3 and z.b = 4  
  

Ergebnis:
$VAR1 = [
          {
            'a' => '1'
          },
          {
            'a' => '5'
          }
        ];

Hotti