![]() SELECT statements do not change data in the database. To perform this operation, the Microsoft Jet database engine searches the specified table or tables, extracts the chosen columns, selects rows that meet the criterion, and sorts or groups the resulting rows into the order specified. The name of the database containing the tables in tableexpression if they are not in the current database. ![]() The name of the table or tables containing the data you want to retrieve. The names to use as column headers instead of the original column names in table. If you include more than one field, they are retrieved in the order listed. The names of the fields containing the data you want to retrieve. The name of the table containing the fields from which records are selected. Specifies that all fields from the specified table or tables are selected. If none is specified, the default is ALL. Use the predicate to restrict the number of records returned. One of the following predicates: ALL, DISTINCT, DISTINCTROW, or TOP. The SELECT statement has these parts: Part Instructs the Microsoft Access database engine to return information from the database as a set of records.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |