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
- RE: Exists and Not exists Budiono Tjiayono
- RE: Exists and Not exists Cal Evans