Which query selects data from one or more tables, and then displays it in the order in which the user wants to display it
Answers
Answer:
plz follow me and like.
Explanation:
Query: Statement that allows data retrieval
View: A virtual table; a saved query (the SELECT statement, not the result)
SELECT statement (DML)
- retrieves a limited set of data from one or more tables using criteria specified in the WHERE clause
- often used to perform calculations on the data selected
- the result set is displayed as a table (columns and rows)
Single-table example (review):
Current Product List: all data comes from the Products table
SYNTAX
SELECT column list
FROM tablename
WHERE criteria
ORDER BY column list
Select from two tables: Example
Run the Orders Query (Orders Qry on the Query list): It lists all orders for all customers, without going into line items (order details), by retrieving related data from the Orders and Customers tables.
Note the number of rows and columns; several columns are repeated more often than strictly necessary.
Use the drop-down list next to the View button (circled above) to switch to SQL view. This is the SQL statement, separated into logical sections for ease of interpretation:
SELECT
Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;