RE: [PHP-DB] Re: JOIN in embedded query
| From: | Russ | Date: | Thu, 08 Aug 2002 03:12:55 +0000 |
| Subject: | RE: [PHP-DB] Re: JOIN in embedded query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21056@lists.php.net to get a copy of this message | ||
Michael:
Post the error that MySQL or whatever DB you're using, gives you.
You might also try the LEFT JOIN syntax beforehand though... you never
know..
Russ
-----Original Message-----
From: Michael Hendsbee [mailto:info@rostoplasc.com]
Sent: Friday, August 02, 2002 5:57 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: JOIN in embedded query
UPDATE Emails SET Sent = 'T' WHERE ID = (SELECT Emails.ID FROM Emails
RIGHT
JOIN KeyWords ON Emails.ID = KeyWords.EmailsID) LIMIT 250
I am getting an error, and I know it's an error in my syntax.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php