What steps should you take to construct a detailed query in a step-by-step fashion?
1 . List in the SELECT clause all the columns that you want to display. If the name of a column appears in more than one table, precede the column name with the table name.
2 . List in the FROM clause all the tables involved in the query. Usually you include the tables that contain the columns listed in the SELECT clause. Occasionally, however, there might be a table that does not contain any columns used in the SELECT clause but that does contain columns used in the WHERE clause. In this case, you must also list the table in the FROM clause.
3 . Take one pair of related tables at a time and indicate in the WHERE clause the condition that relates the tables. Join these conditions with the AND operator. If there are any other conditions, include them in the WHERE clause and connect them to the other conditions with the AND operator.
You might also like to view...
Roger works for a firm that has many levels in its organizational hierarchy. At each level of management, the number of subordinates is small so that managers can spend more time with each employee. The span of control at Roger's firm is said to be
A. narrow. B. high. C. vertical. D. wide. E. flat.
A work sheet heading is dated for a period of time
Indicate whether the statement is true or false
Which of the following is not an objective of management accounting?
A) To prepare external reports for investors, creditors, government agencies, and other outside users. B) To provide information for costing of services, products, and other objects of interest to management. C) To provide information for planning, controlling, evaluating, and continuous improvement. D) To provide information for decision making.
In times of rising prices LIFO produces the lowest net income
Indicate whether the statement is true or false