I think a quick way to write this query would be
( SELECT magazine FROM pages )
( SELECT magazine FROM pdflog )
ORDER BY magazine;
Unimin Corporation - Spruce Pine
Ed Curtis <ed@stripped> wrote on 08/09/2004 12:10:16 PM:
> > What he is really missing is the WHERE clause that matches something
> > pages with something from pdflog.... Without it he is requesting a
> > Cartesian product of his tables (every combination of each row from
> > 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
> way this particular person wants this done. What I need to produce is a
> distinct list from pages.magazine and pdflog.magazine without a
> Just a list of all data in these table columns without duplicates.