Re: Multiple queries into a single temp table

In article <350713BC.5E235B09@dgs.dgsys.com>, Steve Dussinger <sdussin@dgs.dgsys.com> writes >Since my experience with SQL up to this point has been pretty weak (I >know how to do basic stuff, but other >than that I'm utterly lost :--(), I'm hoping someone out there can help >me. > >The problem is this: > > I have several queries I wish to do, and I want to place the results >of all of these different queries into > 1 temp table, so I can return that to my program. > > I tried the following: > > select 1 col1, dealer_id col2 from dealer into temp >dlr_manu_tbl; then insert into dlr_manu_tbl select 2 col1, manufacturer_id col2 from manufacturer > select 2 col1, manufacturer_id col2 from manufacturer into temp >dlr_manu_tbl; > > This failed, telling me that the table dlr_manu_tbl exists when the >second select runs. > > Can anyone tell me if this is even possible, and if so how I can do >it. Any other suggestions on how > I might get similar behavior would also be appreciated. > > NOTE: The queries I'm going to be using to populate the temp table >are considerably more complex > than the ones shown here. These are simplistic examples I was using >to try to solve the problem > > Thanx in advance, > Steve Dussinger > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care