Questions in topic: outer-join - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: outer-join

2

votes

4

answers

126

views

Complicated Joins

Feb 20 at 03:35 AM KenJ 12.4k

index blocking join outer-join nolock

0

votes

1

answers

390

views

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

May 08 '12 at 05:16 PM Kev Riley ♦♦ 46.1k

outer-join top optimizer scan-event

0

votes

2

answers

704

views

left join "on conditions" using outer apply

Nov 29 '11 at 12:29 PM dbf 11

outer-join

0

votes

1

answers

393

views

Counts across different tables producing strange results

Oct 13 '11 at 05:16 AM Magnus Ahlkvist 13.7k

null count outer-join

0

votes

4

answers

902

views

Join Two tables with missing value

Sep 21 '11 at 10:33 AM sqlnewb 216

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

1

votes

1

answers

2.3k

views

Alternative to left (or right) outer join

Jun 10 '11 at 05:45 AM Fatherjack ♦♦ 38.8k

sql-server-2005 query tsql syntax outer-join

1

votes

6

answers

685

views

Subbquery Maximum Dates

Mar 25 '11 at 01:27 PM ThomasRushton ♦ 29.4k

joins subquery outer-join

1

votes

3

answers

1.7k

views

Join another table to full outer join results from cte

Mar 23 '11 at 12:04 PM ThomasRushton ♦ 29.4k

query-results outer-join

1

votes

3

answers

666

views

OUTER JOIN Not returning all rows

Feb 10 '11 at 05:43 PM KenJ 12.4k

outer-join

0

votes

3

answers

710

views

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

Sep 02 '10 at 08:43 AM EdithCamarillo 1

t-sql query outer-join

10 questions

24answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1834
sql-server-2008 × 1601
t-sql × 913
query × 321
tsql × 224
joins × 100
index × 44
query-results × 32
null × 25
blocking × 22
count × 21
join × 15
subquery × 12
syntax × 12
outer-join × 10
top × 9
optimizer × 4
nolock × 3
scan-event × 2

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.