|
-
Nov 16th, 2000, 01:46 PM
#1
Thread Starter
Addicted Member
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.....
-
Nov 16th, 2000, 04:33 PM
#2
Fanatic Member
do a union
select * from tbl1
union
select * from tbl2
-
Nov 17th, 2000, 05:44 AM
#3
Fanatic Member
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...
-
Nov 17th, 2000, 07:53 AM
#4
Thread Starter
Addicted Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote