If we have a table called customers in our current database, and we would like to request a list of customers with the transaction dates of their orders, the script may look as follows: CREATE VIEW transactions ASĪfter we execute this statement, the transactions object will be available in Views. select-statement is a specified SELECT statement that can query data from tables or views.defines the required list of columns that can be indicated in parentheses after the view name by default, the list of columns is retrieved from the select list of the SELECT statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |