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