Exists and Not exists

["Budiono Tjiayono" <budiono@xxxxxxxxxx>]

Hi there,
I am a mysql newbie. Is there anybody that can help me solve this code, so that it can run on mysql


$sql="CREATE TEMPORARY TABLE tempingr SELECT resepid FROM resep r WHERE NOT EXISTS 
                 (SELECT * FROM what_ingr w WHERE w.resepid=r.resepid and NOT EXISTS 
                     (SELECT * FROM Temp_Ingredient t WHERE t.selectedingr=w.ingrid))";
 $results=mysql_query($sql, $con) or die("Can't retrieve data from database, please contact the author");


Thanks you.

Budi