What is wrong with this query?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
 

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux