10 messages in com.mysql.lists.mysqlSelecting data from 2 tables.
FromSent OnAttachments
Ed Curtis09 Aug 2004 08:26 
Martijn Tonies09 Aug 2004 08:38 
Ed Curtis09 Aug 2004 08:43 
SGr...@unimin.com09 Aug 2004 08:44 
Ed Curtis09 Aug 2004 08:47 
Ed Curtis09 Aug 2004 09:09 
SGr...@unimin.com09 Aug 2004 09:16 
Ed Curtis09 Aug 2004 09:33 
SGr...@unimin.com09 Aug 2004 09:36 
Martijn Tonies09 Aug 2004 09:38 
Subject:Selecting data from 2 tables.
From:Ed Curtis (ed@homes2see.com)
Date:08/09/2004 08:26:31 AM
List:com.mysql.lists.mysql

God, I feel real stupid this morning and know I should know this. I have 2 tables in the same database and I'm trying to select distinct data from a row with the same name in each table.

SELECT DISTINCT company FROM pages, pdflog ORDER BY company ASC

I'm missing something I'm sure because it doesn't work.

Thanks,

Ed