SELECT     *
FROM         loket2007
WHERE     (no_registrasi LIKE '2011%') AND (no_registrasi NOT IN
                          (SELECT     no_registrasi
                            FROM          agenda_sk)) AND (id_layanan_l <> '43') AND (status <> 'Ditolak')