Re: [PHP-DB] What is wrong with this query?

2005-01-23 Thread just roibm
A better idea would be, back to basics, back to learning SQL. Otherwise you'll get PLENTY rows and don't even know why ;) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] What is wrong with this query?

2005-01-22 Thread Chris Payne
Hi there, Basically I just need to pull ALL the data from ALL the tables listed in the same query. It doesn't matter in what order the data is displayed and there is no relation between the tables. Chris What exactly are you trying to do? If you require data from each table and that data is li

RE: [PHP-DB] What is wrong with this query?

2005-01-22 Thread Bastien Koert
What exactly are you trying to do? If you require data from each table and that data is linked somehow thur some common field (not required to be the same field across all three tables) you need to include that SELECT a.*, b.*,c.* FROM MLS a, Cond b, Comm c where [join crtieria] and [search crt