New topic: combining record sets from two separate databases.
<http://forums.realsoftware.com/viewtopic.php?t=46580> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message BrianOBrien Post subject: combining record sets from two separate databases.Posted: Wed Jan 16, 2013 2:16 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 651 Location: University Of Calgary, Faculty Of Medicine I have two databases (MySQL, Sybase) that contain nearly identical tables. Of course one table has data that the other doesn't and vise versa. I need to perform two selects and combine the results of the selects into one report, selecting columns from one record set and columns from the other record set. The result of the selects should result in recordsets with identical numbers of rows and ordered in the same fashion. How can I combine these two record sets into one record set that I can generate a report with? Or how would you approach this problem? _________________ If at first you don't succeed... Try REALBasic. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
