CODEWITHSUNDEEP
sqljoinssms
Mason Chambers
Mason Chambers

Reputation: 173

Can't make any table joins in query

I am trying to write a simple query that joins two tables, but when I type any kind of join Inner Join, Outer join, Left Join, etc the text is greyed out instead of blue.

I even cut my query down to simple

SELECT *
from TableA
Outer Join TableB on TableA.column1 = TableB.column1

... and the text is still greyed out. If I try running the query anyway, it kicks out an error:

incorrect syntax near keyword join

Upvotes: 0

Views: 1125

Answers (2)

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 32003

try like below is that left, right or full outer? i used left just for example

    SELECT a.*,b.* from TableA a left Outer Join 
     TableB b on a.column1 = b.column1

Upvotes: 1

The Impaler
The Impaler

Reputation: 48770

Any of these will work:

SELECT * from TableA LEFT Outer Join TableB on TableA.column1 = TableB.column1

SELECT * from TableA RIGHT Outer Join TableB on TableA.column1 = TableB.column1

SELECT * from TableA FULL Outer Join TableB on TableA.column1 = TableB.column1

You need to pick one of these. There isn't a unique type of OUTER JOIN.

Upvotes: 1

Related Questions