On Mon, 9 Aug 2004 [EMAIL PROTECTED] wrote: > He does have a join. He has an *implied* INNER JOIN > (http://dev.mysql.com/doc/mysql/en/JOIN.html): > > FROM pages, pdflog > > 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
Like I said I knew I was missing something. I just couldn't for the life of me remember what it was. All I needed was a nudge. Thanks all, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]