Re: Selecting data from 2 tables.

[Martijn Tonies]

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