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
How to enter comments in transact-sql statements?
What is difference between after and before?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain timestamp datatype?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is transaction server auto commit?
What is the synonym of join?
How you can get the list of largest tables in a database?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Explain collation?
What command do we use to rename a database?
What do you understand by the analysis services in sql server?
Is the primary key column of a table an index in ms sql server?
Why do we use functions?