outer-join Image

outer-join

question
KenJ avatar image
KenJ commented Default

sql joins to get records from one table and matching records from other table

joins join outer-join

0 Likes

1Answer

0 Comments

question
Squirrel avatar image
Squirrel answered Default

Joining and Grouping data from 3 tables

sql-server-2008 joins group-by mssql outer-join

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Complex LEFT OUTER JOIN or OUTER APPLY / NULL problem

query-tuning outer-join

2 Likes

3Answers

2 Comments

question
KenJ avatar image
KenJ commented Default

Complicated Joins

index join blocking outer-join nolock

This question has an accepted answer. Accepted

2 Likes

4Answers

2 Comments

question
Kev Riley avatar image
Kev Riley commented Default

Why is index scan run on outer join when not using "SELECT TOP"

top outer-join optimizer scan-event

0 Likes

1Answer

7 Comments

question
dbf avatar image
dbf edited Default

left join "on conditions" using outer apply

outer-join

0 Likes

2Answers

1 Comment

question
Magnus Ahlkvist avatar image
Magnus Ahlkvist edited Default

Counts across different tables producing strange results

count null outer-join

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
sqlnewb avatar image
sqlnewb asked Default

Join Two tables with missing value

sql-server-2008 t-sql joins outer-join

0 Likes

3Answers

1 Comment

question
Fatherjack avatar image
Fatherjack edited Default

Alternative to left (or right) outer join

sql-server-2005 query tsql syntax outer-join

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
ThomasRushton avatar image
ThomasRushton edited Default

Subbquery Maximum Dates

joins subquery outer-join

This question has an accepted answer. Accepted

1 Like

6Answers

0 Comments

question
ThomasRushton avatar image
ThomasRushton edited Default

Join another table to full outer join results from cte

query-results outer-join

This question has an accepted answer. Accepted

1 Like

2Answers

1 Comment

question
KenJ avatar image
KenJ edited Default

OUTER JOIN Not returning all rows

outer-join

1 Like

3Answers

0 Comments

question
EdithCamarillo avatar image
EdithCamarillo edited Default

retrieve date from a table only if isn't in the second table

t-sql query outer-join

0 Likes

1Answer

0 Comments

13 Posts
13 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.