I am having some trouble creating a view on my database
If i run the query in a normal window the query runs returns all the data i require
When i copy that query to create a view i keep getting this error
multi-part identifier cannot be bound
could some one please explain to me what the issue could be and a possible solution.
Thanks in Advance