Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

data joins

3 Posts 3 Posters 0 Views 1 Watching

M Offline
M Offline
Member 4708077

wrote on last edited by

#1

in sql server have the 2 tables first table have the 5 rows and second table have the 10 rows when we apply the left outer join the tables . whats the no of rows selected in best case and worst case can u explain this?

raja
B R 2 Replies Last reply

0
M Member 4708077

in sql server have the 2 tables first table have the 5 rows and second table have the 10 rows when we apply the left outer join the tables . whats the no of rows selected in best case and worst case can u explain this?

raja
B Offline
B Offline
Blue_Boy

wrote on last edited by

#2

Post your query and we will see what's wrong.

I Love T-SQL
1 Reply Last reply

0
M Member 4708077

in sql server have the 2 tables first table have the 5 rows and second table have the 10 rows when we apply the left outer join the tables . whats the no of rows selected in best case and worst case can u explain this?

raja
R Offline
R Offline
Rami Said Abd Alhalim

wrote on last edited by

#3

can you post query
1 Reply Last reply

0

Log in to reply