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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]