Results 1 to 4 of 4

Thread: 2 queries, 1 recordset

  1. #1

    Thread Starter
    Addicted Member ender_pete's Avatar
    Join Date
    Aug 2000
    Location
    Virginia, United States
    Posts
    131

    Question

    i want to insert the results of 2 queries into 1 recordset
    the queries have all the same fields and stuff...
    i just need to know if it is possible so i don't sit here and waste time trying to get it to work.
    thanks
    ender_pete
    C#,VS.NET Ent Arch, vb6 ee sp5,html,vbscript,jscript,
    xml,dhtml,delphi,c++,vc++,java,cgi,php, python, ada(so ancient) ,adasage(also ancient) and others i can't remember.....

  2. #2
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    do a union

    select * from tbl1
    union
    select * from tbl2

  3. #3
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    Don't forget that a UNION query is read-only. If you want to update it, create a temporary table...

    Cheers,

    P.
    Not nearly so tired now...

    Haven't been around much so be gentle...

  4. #4

    Thread Starter
    Addicted Member ender_pete's Avatar
    Join Date
    Aug 2000
    Location
    Virginia, United States
    Posts
    131
    i forgot all about unions
    thanks guys
    ender_pete
    C#,VS.NET Ent Arch, vb6 ee sp5,html,vbscript,jscript,
    xml,dhtml,delphi,c++,vc++,java,cgi,php, python, ada(so ancient) ,adasage(also ancient) and others i can't remember.....

Posting Permissions

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



Click Here to Expand Forum to Full Width