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

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

Question Posted / prabir4prabir

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

Answer / prabir4prabir

It will act as a inner join.

Is This Answer Correct ?

4 Yes

1 No

More SQL Server Interview Questions

Determine how to use the inserted and deleted pseudo tables?

Explain Active/Active and Active/Passive cluster configurations?

Can primary key be a foreign key?

What is the maximum size of a row in sql server?

What is molap and its advantage? : sql server analysis services, ssas

How to find the latest updated value in a table without sending any parameters to that query

What is the recursive stored procedure in sql server?

What are key, name and value columns of an attribute? : sql server analysis services, ssas

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

Explain about remote stored procedure?

What is the usage of the sign function?

What is sql language?

For more SQL Server Interview Questions Click Here