SQL Queries
| From: | דניאל דנון | Date: | Sun, 20 Dec 2009 21:30:56 +0000 |
| Subject: | SQL Queries | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-300617@lists.php.net to get a copy of this message | ||
Hey, Lets assume I got a table named "users".
It contains id & name.
I have another table called "notes" - which contains id, user_id, contents
I want to delete all users from table "users" that don't have notes (SELECT
... FROM notes WHERE user_id=ID) returns empty result.
What is the fastest way to do it?
--
Use ROT26 for best security