Re: SELECT FROM 2 or more tables
| From: | John Ryan | Date: | Thu, 21 Aug 2003 02:38:16 +0000 |
| Subject: | Re: SELECT FROM 2 or more tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30015@lists.php.net to get a copy of this message | ||
ive heard that before, and its in the mysql manual, to have something like
"WHERE table1.id = table2.id"
But does make any sense to me.
What Im doing is providing a search form for customers that allows them to
search each individual table for content or all tables. all tables have a
common field, keywords, which i have searched.
maybe im stupid, but i cant c where "WHERE table1.id = table2.id" would
help, or sumting along that lines
"John Ryan" <celticfc@iol.ie> wrote in message
news:20030820194053.28615.qmail@pb1.pair.com...
> Is it easy?? Is it possible?? Should I just run 2 different queries and
> output their results in the PHP script and make it look like it's all from
> the same table
>
> I cant grasp JOIN for the life of me
>
>