SELECT 
  VORNAME, NACHNAME, EMAIL, BRANCHE01
FROM 
  [PLZ70000-79999]
WHERE 
  (PLZ Between '70000' AND'75999') AND
  (EMAIL IS NOT NULL OR EMAIL <> "") AND
  ((BRANCHE01 IS NULL) OR (BRANCHE01 NOT LIKE "%Steuer%" AND
                           BRANCHE01 NOT LIKE "%Design%" AND
                           BRANCHE01 NOT LIKE "%Werb%" AND
                           BRANCHE01 NOT LIKE "%Recht%" AND
                           BRANCHE01 NOT LIKE "%Reklame%" AND
                           BRANCHE01 NOT LIKE "%Marketing%"));

SELECT 
  VORNAME, NACHNAME, EMAIL, BRANCHE01
FROM 
  [PLZ70000-79999]
WHERE 
  (BRANCHE01 Not Like "%Steuer%");

-- 
-- Tabellenstruktur für Tabelle `zeug`
-- 

CREATE TABLE `zeug` (
  `branche01` varchar(20) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- Daten für Tabelle `zeug`
-- 

INSERT INTO `zeug` VALUES ('Designer');
INSERT INTO `zeug` VALUES ('Steuerberater');
INSERT INTO `zeug` VALUES ('Finanzjongleur');
INSERT INTO `zeug` VALUES ('Artist');
INSERT INTO `zeug` VALUES ('Schauspieler');
INSERT INTO `zeug` VALUES ('Programmierer');
INSERT INTO `zeug` VALUES ('Links vor Rechts');
INSERT INTO `zeug` VALUES ('Rechtsverdreher');
INSERT INTO `zeug` VALUES ('einmal Marketing');
INSERT INTO `zeug` VALUES ('und zurück');

SELECT * FROM zeug WHERE (branche01 NOT LIKE '%Rechts%' AND branche01 NOT LIKE '%Marketing%')