What should you use to display specific information from a database table?
Type SELECT, followed by the names of the columns in the order that you want them to appear on the report. Use commas to separate the column names.
For example, to select the DEPTNAME and DEPTNUMB columns, type SELECT DEPTNAME, DEPTNUMB Show To select all columns in the table, type SELECT *
|