Selecting data from 2 tables.

[Ed Curtis]

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