Yes - not pretty. One view using UNION should work fine. If you provide the source table layouts, I will provide the CREATE VIEW statement.
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Barley > Sent: October 10, 2008 11:02 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Group By Problems > > Stephen and Dan, > Thanks for your help. After many long hours, I have finally gotten the > results I needed! I never could get the UNION SELECT to work properly, > kept > getting error messages. What I ended up doing was using both of your > solutions in a way! I create my 3 views, then create a temp table, append > the first view to the temp table, delete duplicates, then update the temp > table with the values I need from the 3 views! Ain't the prettiest > programming you may have seen, but it works! Thanks again for your help! > > Jan Barley > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.173 / Virus Database: 270.7.5/1704 - Release Date: 10/9/2008 > 4:56 PM
