It will act as a inner join.

If we use where clause in the left outer join then how the
query would behave/act?

Question Posted / prabir4prabir

Answer Posted / prabir4prabir

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What the different components of Replication and what is their use?

1051

How to convert binary strings into integers in ms sql server?

1003

What is difference between Datepart() and Datename() in SqlServer?

1187

Tell me what is the difference between locking and multi-versioning?

1005

What are the steps you will take to improve the performance of a poor performing query?

957

Can I disable or restrict ssrs export formats (rendering formats)?

148

How to generate random numbers with the rand() function in ms sql server?

1122

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

985

How to create a new login name in ms sql server?

1040

Is mysql better than sql server?

1043

How to create median function?

164

How you can minimize the deadlock situation?

1016

What does man by sql wildcard characters in sql server?

1039

What is the Disadvantage of indexed sequential file.

1063

Explain logical operators in sql server?

1086