RE: [PHP-DB] Sub_select problem
| From: | Robert Hall | Date: | Tue, 27 Jun 2000 14:25:47 +0000 |
| Subject: | RE: [PHP-DB] Sub_select problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-661@lists.php.net to get a copy of this message | ||
-----Original Message-----
WHERE (SELECT equip_id
I haven't done sub-selects in pgsql before, but doesn't it require a
predicate or comparison operator between WHERE and (SELECT? Something like
WHERE EXISTS (SELECT
or
WHERE equip_id = ANY (SELECT
?
And where did equip_id come from? It's not listed in your lists of table
fields. (I occasionaly try to SELECT non-existant fields, so it seems like
an obvious thing to check.)
Bob Hall