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
