SELECT * FROM artcol
WHERE NOT EXISTS (
SELECT * FROM artikel
WHERE artikel.color_id = artcol.color_id
);

SELECT * FROM artcol
WHERE NOT EXISTS (
SELECT * FROM artikel
WHERE artikel.color_id = artcol.color_id
);

SELECT * FROM artcol
WHERE color_id NOT IN (
SELECT color_id FROM p_farben
);

1: SELECT * FROM artcol
2: WHERE color_id NOT IN (
3: SELECT color_id FROM p_farben
4: );

#
# Table structure for table artcol
#

CREATE TABLE `artcol` (
  `color_id` int(6) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`color_id`)
) TYPE=MyISAM;


#
# Table structure for table artikel
#

CREATE TABLE `artikel` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `color_id` tinyint(4) default NULL,
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

SELECT feld1, feld2, ... 
    FROM artcol a
    LEFT JOIN artikel b on a.color_id = b.color_id
    WHERE ISNULL(b.color_id);