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

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

How to how to convert numeric expression data types using the convert() function??

How to create a user to access a database in ms sql server using "create user" statements?

What is table level trigger?

What do you understand by triggers?

What are policy management terms?

What the different topologies in which replication can be configured?

What is catalog views?

How to find the service pack installed? : sql server database administration

how to dispaly a particular row details from a given table

What is the difference between insensitive and scroll cursor?

Explain the concepts and capabilities of sql server?

For more SQL Server Interview Questions Click Here