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 news:[EMAIL PROTECTED] > 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