CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. October 16th, 2001, 12:04 AM #1
    rajeshrakyan
    rajeshrakyan is offline Junior Member
    Join Date
    Oct 2001
    Location
    India, Calcutta
    Posts
    17

    Joining two recordsets

    Hi

    I have very complex query to execute. So what i am trying to do is to two break down the complex query in two queries . now i would like to join the results of the two query in one recordset. is it possible ?

    Reply With Quote Reply With Quote
  2. October 16th, 2001, 06:13 AM #2
    sead
    sead is offline Member
    Join Date
    Jul 2000
    Posts
    223

    Re: Joining two recordsets

    If memory serves, you should be able to do that with UNION query which allows you to combine fields from two (or more) queries (or tables) into the one field. Search MSDN or this forum for details...

    Hope this helps,
    Have a nice day

    Sead
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured