Hello, I am very green in SQL and am trying to create a view from multiple tables in SQL. I do not what the common columns to be duplicated in the view. I have seen some syntax statements that show
CREATE VIEW view_name AS
but when I type a name for my view it show errors... Can anyone help?
What is the error you get?
And do you have a valid/working SELECT statement for which you want to create a view?