Sandeep- If by "project" you mean an adp application, SQL Server works the same way as Access. You must build a View first that is your UNION query and then build a Function or Stored Procedure for your SELECT INTO that uses the union View in the FROM clause.
John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of sandeep ta Sent: Friday, August 12, 2005 12:23 AM To: ms_access@yahoogroups.com Subject: [ms_access] how to create temporary table......... Hello, I am in middle of the project and i stuck in a problem where i wan t to use many queries and the output of that should made table. for ex. query1 union query2 union query3 union .. .. .. i want to create table to The output of the above. Can anybody help me in solving this. Sandeep T.A [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hdhulvf/M=362329.6886308.7839368.1510227 /D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123831344/A=2894321/R=0/SIG=11dvsfulr /*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hi27rke/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123857889/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/