By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,722 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,722 IT Pros & Developers. It's quick & easy.

two queries in one

P: n/a
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

thanks
Gordan
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gordan wrote:
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

thanks
Gordan


take a look into mysql documentation chapter 14.1.4.1 INSERT ... SELECT
Syntax (http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html).

Greetings, Urs
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.