What is wrong with this query?
| From: | Chris Payne | Date: | Sun, 23 Jan 2005 04:44:29 +0000 |
| Subject: | What is wrong with this query? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38265@lists.php.net to get a copy of this message | ||
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