> What he is really missing is the WHERE clause that matches something from > pages with something from pdflog.... Without it he is requesting a > Cartesian product of his tables (every combination of each row from both > tables). > > I prefer to define my JOINS *explicitly*. It makes it harder to > accidentally define Cartesian products): > > SELECT DISTINCT company > FROM pages > INNER JOIN pdflog > ON ...some condition goes here .... > ORDER BY company > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
OK now I really really feel stupid. Now that I've been given the correct way this particular person wants this done. What I need to produce is a distinct list from pages.magazine and pdflog.magazine without a condition. Just a list of all data in these table columns without duplicates. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
