I have 4 tables I want to query at once and also use WHERE. The WHERE is the same for all tables, same field name and I'm looking for the same value for all 4. I'm not getting it to work. I've tried these two statments and the first wont query and second gives me no reults. Of course there is data in the tables..

Code:
 
 
$sql = "SELECT * FROM table1, table2, table3, table4 WHERE catagory = '$catagoryname'";
 
$sql = "SELECT * FROM table1, table2, table3, table4 WHERE table1.catagory = '$catagoryname' AND table2.catagory = '$catagoryname' AND table3.catagory = '$catagoryname' AND table4.catagory = '$catagoryname'";
Not sure how to do it. Any help would be greatly appreciated.
Thanks.

ronnie