two queries in one

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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 echo 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 and doing a INSERT for every
line but I would like to do it via a query


Re: two queries in one

Gordan wrote:
Quoted text here. Click to load it

take a look into mysql documentation chapter INSERT ... SELECT
Syntax (">

Greetings, Urs

Site Timeline