i have a view and i need a field that is not existed in none of my tables
i want to know if it is possible to create a new field in this view in sql?
this field is not a calculated or something else
it is not related to none of other fields in this view
can you help please?
no it is just a field and then i want to import (link) this table to ms access and then enter the values manually to the form and saving them to this view
Please learn SQL. The term "field" in SQL is part of a temporal value = {YEAR, MONTH, DAY, HOUR, MINUTE, SECOND }. A field in a file is nothing like a column in SQL!
Did you ,mean a column? And yes, you can add an expression to the SELECT list of a VIEW.