two queries in one

  • Thread starter Thread starter Gordan
  • Start date Start date
G

Gordan

can the following be done in an access DB:
I have a query like this "SELECT fld1, fld2, fld3 FROM table WHERE something
GROUP BY fld1"
Usually I just resppnse.write that result on screen but now I would have to
store it
to another (new) table
Can it be done via a query?
I know how to do it by looping through results in ASP and doing a INSERT for
every
line but I would like to do it via a query

thanks
Gordan
 
INSERT INTO Table2
SELECT fld1, fld2, fld3 FROM table WHERE something
GROUP BY fld1

assuming that Table2 only has 3 fields in it (and they match in data type to
the 3 fields being selected: the names don't matter), otherwise

INSERT INTO Table2 (flda, fldb, fldc)
SELECT fld1, fld2, fld3 FROM table WHERE something
GROUP BY fld1
 
Try a Make-Table Query (SELECT INTO ... syntax).

See Access Help on Make-Table Query / SELECT INTO ... SQL syntax.
 
Is this into a Non-existing table. Here is an example

SELECT FAQ.fID, FAQ.fSubject INTO BrandNewTable
FROM FAQ
GROUP BY FAQ.fID, FAQ.fSubject;

Into an existing table.

INSERT INTO SomeExistingTable ( fID, fSubject )
SELECT FAQ.fID, FAQ.fSubject
FROM FAQ
GROUP BY FAQ.fID, FAQ.fSubject;
 
Back
Top