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
Printable View
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
select * from tbl1
union
select * from tbl2
Don't forget that a UNION query is read-only. If you want to update it, create a temporary table...
Cheers,
P.
i forgot all about unions
thanks guys