KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to join a common table expression to an existing table (table1) as follows. select column1, column2 from table1 left outer join ;with cte as ( select column1, column2 from table2) select column1, column2 from cte on table1.column1 = cte.column1 The errors are: Incorrect syntax near ';'. Incorrect syntax near the keyword 'on'. What am I doing wrong? Should I be using a CTE for this task?
Tags (comma-separated)
Save Edits
Cancel