Phone icon for calling web design Call Today:

  • (519) 204-6201 (CA)
  • (612) 594-4495 (cell)

Concerto Designs Minneapolis Joomla Web Design medallion logo

Show Missing Entries with Mysql 'WHERE NOT EXISTS'

    SELECT DISTINCT ( `sul4t_jsn_users`.`id` ), `sul4t_jsn_users`.`firstname`, `sul4t_jsn_users`.`lastname` FROM `sul4t_jsn_users` JOIN `sul4t_newcardsame` ON `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id` JOIN `sul4t_newcardmultiple` ON `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id` JOIN `sul4t_newcard_sundays2016` ON `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardsame`.`weekEnding2016` AND `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardmultiple`.`weekEndingMultiple2016` WHERE NOT EXISTS ( SELECT `memberName` FROM `sul4t_newcardsame` WHERE `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardsame`.`weekEnding2016` = '1' AND `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardmultiple`.`weekEndingMultiple2016` = '1') ORDER BY `lastname` ASC