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 20030820194053.28615.qmail@pb1.pair.com">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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php