DATABASES:DESIGNING A QUERY The real power of a relational database is in the ability to quickly retrieve and analyse your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-table query. Then you will learn how to plan and run a slightly more complex multi-table query.
DATABASES:DESIGNING A QUERY
The real power of a relational database is in the ability to quickly retrieve and analyse your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define.
In this lesson, you will learn how to create a simple one-table query.
Then you will learn how to plan and run a slightly more complex multi-table query.
DOWNLOAD THE EXAMPLE HERE
THEN OPEN THIS WEB PAGE Follow the instructions through ALL 8 PAGES to understand how to create a query.