Re: DB_DATAOBJECT extended join ...
| From: | Alan Knowles | Date: | Sat, 28 Feb 2004 03:07:19 +0000 |
| Subject: | Re: DB_DATAOBJECT extended join ... | ||
| References: | 1 | Groups: | php.pear.general php.pear.general |
| Request: | Send a blank email to pear-general+get-11009@lists.php.net to get a copy of this message | ||
eh.. - not quite sure what you are trying to do there...
AFAIK - the on condition in the join will only do a single a=b.
Regards
Alan
Daniel Kopp wrote:
Hi! Actually I wonder whether this is allowed but it works: how can I do: SELECT * FROM table1 LEFT JOIN table2 ON (table1.foo = table2.foo AND table2.bar=$value) Does it have a name? Or is that called "wrong" or "bad style" or "lucky that it works" or something? regards Daniel-- Can you help out? Need Consulting Services or Know of a Job? http://www.akbkhome.com