OT: UNION vs JOIN

Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and

Re: OT: UNION vs JOIN

Union Adds the rows from a second table, Join combines the tables. It's conceivable that they produce the same result if you're using an outer join, but they're different. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL