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" <[EMAIL PROTECTED]> wrote in message
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php