December 5th, 2012, 08:31 AM
View and table with the same name
If you have one table called CUST_ACCOUNTS and a view called CUST_ACCOUNTS -- and then you want to select from the view and not the table, how do you do that?
Is there a prefix for views or something that I can have in front of the name to specify it's the view I want data from?
December 5th, 2012, 09:25 AM
You cannot have a view and a table with the same name.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: