Generally, table relationships will be added as part of the database design process, and they would need to be in place before creating multi-table queries. Table relationships are a big topic, but this article goes over some of the main concepts: www.techrepublic.com/article/relational-databases-defining-relationships-between-database-tables/. We hope it helps!
I need to create a query for the customer table that lists all states in ascending order. Each state should appear only once. No problem with the ascending order but I do not know how to make it appear only once.
It sounds like you may need a totals query. A totals query can aggregate the data for each state, which will allow you to have a single row for each state. This lesson has more information about totals queries: www.gcflearnfree.org/access2016/more-query-design-options/4/. We hope it helps!
The SQL query is actually very long because we are selecting a number of different fields. However, you can see it by clicking the View drop-down arrow and selecting SQL View. While it’s possible to write queries from SQL View, our tutorials focus on building them in Design View. Hope this helps!
Thanks, I have practicals today. You made my day🖖
What do I do if i'm not seeing a join even though i have two tables
thanks you made my day ,good explanation .
You guys are the best. Saved my time with your tip on 2:52 subscribed
very helpful
Helpful but how can this work with 3 tables without already having the relationship. You had the relationship set up before you added the tables.
Generally, table relationships will be added as part of the database design process, and they would need to be in place before creating multi-table queries. Table relationships are a big topic, but this article goes over some of the main concepts: www.techrepublic.com/article/relational-databases-defining-relationships-between-database-tables/. We hope it helps!
Great memorable criteria thank you
I need to create a query for the customer table that lists all states in ascending order. Each state should appear only once. No problem with the ascending order but I do not know how to make it appear only once.
It sounds like you may need a totals query. A totals query can aggregate the data for each state, which will allow you to have a single row for each state. This lesson has more information about totals queries: www.gcflearnfree.org/access2016/more-query-design-options/4/. We hope it helps!
can you mention the sql query command to perform these filter
The SQL query is actually very long because we are selecting a number of different fields. However, you can see it by clicking the View drop-down arrow and selecting SQL View. While it’s possible to write queries from SQL View, our tutorials focus on building them in Design View. Hope this helps!
Very good explanation but it is not necessary to have the orders table to get the result
So helpful :wink:
how can we creat a single from from which data goes to two tables, both the tables hve one or two different columns
We're not sure what you mean. Can you be more specific about what you're trying to do?