From: Martijn Tonies
Date: August 9 2004 3:38pm
Subject: Re: Selecting data from 2 tables.
List-Archive: http://lists.mysql.com/mysql/170543
Message-Id: <018701c47e26$ec4ad240$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> 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.

Feel stupid again ;-)

Where's your JOIN?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com