// no result SELECT * FROM playlist LEFT JOIN banfile ON banfile.fileid = playlist.clipid WHERE filebanned != 1 // one result SELECT * FROM playlist LEFT JOIN banfile ON banfile.fileid = playlist.clipid WHERE filebanned = 1 // 14 results SELECT * FROM playlist LEFT JOIN banfile ON banfile.fileid = playlist.clipid