I have a view with several joins, including an outer join. The view is run from within a stored procedure. The stored procedure is executed from a custom VB application.
When the custom VB application executes the procedure, it runs ok.
We have a logic problem with the stored procedure (not related to the view in question). I am trying to run the procedure in the SQL Analyzer debugger. However, it errors with the following message:
Joined tables cannot be specified in a query containing outer join operators. View or function '%View_Name%' contains joined tables.
I also get the error when querying the view from Enterprise Manager and SQL Analyzer.
If I take out the text of the view and run it, it works ok.
Any ideas would be appreciated.
When the custom VB application executes the procedure, it runs ok.
We have a logic problem with the stored procedure (not related to the view in question). I am trying to run the procedure in the SQL Analyzer debugger. However, it errors with the following message:
Joined tables cannot be specified in a query containing outer join operators. View or function '%View_Name%' contains joined tables.
I also get the error when querying the view from Enterprise Manager and SQL Analyzer.
If I take out the text of the view and run it, it works ok.
Any ideas would be appreciated.
