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 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 crtieria] ORDER BY Price DESC LIMIT 0, 50 need more info about structure and goal bastien >From: "Chris Payne" <cjp@xxxxxxxxxxxxxxxxx> >To: <php-db@xxxxxxxxxxxxx> >Subject: What is wrong with this query? >Date: Sat, 22 Jan 2005 23:44:29 -0500 > >Hi there everyone, > > > >I’m trying to select data from 3 tables, I’m using the following code: > > > >SELECT * FROM MLS, Cond, Comm ORDER BY Price DESC LIMIT 0, 50 > > > >But it’s not working, I thought this is how it worked but I guess I’m >wrong. >It’s just a basic query, but needs to pull all the info from all 3 tables >in >the same DB, what am I doing wrong? It works perfectly if I just use 1 >table. > > > >Chris > > >-- >No virus found in this outgoing message. >Checked by AVG Anti-Virus. >Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
