Susan Harkins
ssharkins at bellsouth.net
Fri Nov 19 10:40:23 CST 2004
Yeah, I just have this nagging little "tip" that I can't seem to fully remember -- and it may not have anything to do with making UNION updateable, but rather using UNION in some other non-traditional manner. I hate having everything boxed up. :( Susan H. IIRC, UNION ALL doesn't make the query updateable, it just returns all records from the unioned tables, without eliminating duplicate records.