Hey, thanks - nice to learn something. ap
---------------------------------------------------------------------- Andrew J Perrin - http://www.unc.edu/~aperrin Assistant Professor of Sociology, U of North Carolina, Chapel Hill [EMAIL PROTECTED] * andrew_perrin (at) unc.edu On Fri, 17 Jan 2003, Bruno Wolff III wrote: > On Fri, Jan 17, 2003 at 08:57:14 -0500, > Andrew Perrin <[EMAIL PROTECTED]> wrote: > > I'd suggest something similar to, but slightly different from, what others > > have: > > > > SELECT DISTINCT email FROM (SELECT email FROM table_1 UNION SELECT > > email FROM table_2) AS combined; > > > > that way you avoid duplicates across tables. > > The union operator already removes duplicates. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
