The correct answer is C. Both A & B.
A query is a statement that is used to retrieve data from a database. Queries can be used to select data from a single table or from multiple tables. When a query is executed, the database engine will return the results of the query to the user.
To select data from a single table, the query must specify the table name and the columns that you want to retrieve. For example, the following query will select all of the rows from the Customers
table:
SELECT * FROM Customers;
To select data from multiple tables, the query must specify the tables that you want to join and the columns that you want to join on. For example, the following query will select all of the rows from the Customers
table and the Orders
table where the CustomerID
column in the Customers
table is equal to the CustomerID
column in the Orders
table:
SELECT * FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
I hope this helps!