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

Answer Posted / prabir4prabir

It will act as a inner join.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter comments in transact-sql statements?

713


What is difference between after and before?

692


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

782


Explain timestamp datatype?

719


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

105






What is transaction server auto commit?

745


What is the synonym of join?

686


How you can get the list of largest tables in a database?

689


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

816


How do I change my passwords (database, LDAP, and so on) without causing an outage?

785


Explain collation?

790


What command do we use to rename a database?

771


What do you understand by the analysis services in sql server?

704


Is the primary key column of a table an index in ms sql server?

700


Why do we use functions?

681