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

Combiding 2 or more queries into 1 and sorting it! Please Help

P: 49
I'm writing a database to act as a football league table. I have set up idividual tables for each of the teams and then produced a query for each to to work out their totals i.e wins total, draws totals......... etc
I now want to produce a single query to act as a league table from the queries i've writen, then i'll be able to sort the final query into diffents orders, so basically 1 want to combined 12 querys into 1, can anyone help?????
Sep 28 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

Yeah!!! U need to use Union Query! All basis queries have to have the same column names


Each query's SQL you do Copy and you paste it into new SQL query

After the Paste U del the ;

and on a new line you type UNION

Under UNION You type the next one query

After the last one you leave the ;

and you click for query in datasheet view! Save your query! So it will be ready for further manipulations like AS Sort as U want!

Sep 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.