combine recordsets

Results 1 to 2 of 2

Thread: combine recordsets

  1. #1
    Join Date
    Dec 1969

    Default combine recordsets

    i have to recordsets. is there a way i can combine both of the recordsets to get one large recordset??

  2. #2
    Join Date
    Dec 1969

    Default RE: combine recordsets

    I don&#039t know of a way to combine recordsets, but I do know of a way to put the data from both queries into a single recordset. If both queries have the same column names, datatypes, and are in the same order, you can do a union of two select statements.<BR><BR>SELECT FirstName, LastName, Phone<BR>FROM tblEmployee<BR>UNION<BR>SELECT FirstName, LastName, Phone<BR>FROM tblCustomer<BR><BR>That will put the results of both queries into a single recordset.<BR><BR>Hope that helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts