Joining 2 recordsets to create a third recordset

Posted on 2003-04-01
Medium Priority
Last Modified: 2006-11-17
I create a recordset by selecting data from Table1 into RS1. Similarly, I define RS2 from Table2. Now, I want to create RS3 from the join of Table1 and Table2. Is it possible to create RS3 from a join of RS1 and RS2 instead of referring to the physical tables Table1 and Table2 ?
Question by:archie8ue

Accepted Solution

RiverGuy earned 152 total points
ID: 8247671
If you are really using recordsets and ADO, you might be better off asking this in the VB forum.

If you are using ADO.Net and DataSets, look up DataRelation objects in help.  
LVL 11

Assisted Solution

rdrunner earned 148 total points
ID: 8271146
How about filling RS3 this way? (If both tabels come from the same source)

select * from table1
select * from table2

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question