All Forums Database
jstrack13 1 post Joined 01/13
30 Jan 2013
Creating a view from multiple tables in SQL 2012

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?

Tags:
Adeel Chaudhry 773 posts Joined 04/08
02 Feb 2013

What is the error you get?
 
And do you have a valid/working SELECT statement for which you want to create a view?
 
Regards, Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.