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
