blubblubb: MySQL: SELECT mit IN()

Beitrag lesen

  
SELECT    slt1.nr             slot_nr  
         ,kon1.id             kon_id  
         ,kon1.besucher_id  
FROM      tm_slots slt1  
LEFT JOIN tm_kontakte kon1  
ON        kon1.slot_nr=slt1.nr AND  
WHERE     slt1.owner_id=5 AND kon1.besucher_id IN (3713,3714)  
GROUP BY  slt1.nr  

HTH