In join, which clause in not used?

Answer Posted / b.kumar

--Ms sql server
We can't use where clause in joins(inner/left/right/full).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference function and stored procedure?

567


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2091


Explain what is dbcc?

603


What is sql server profiler trace data file?

593


List out some of the requirements to set up a sql server failover cluster?

557






How we can compare two database data?

527


How to enter comments in transact-sql statements?

561


When would you use the stored procedures or functions?

588


Explain powershell included in sql server 2008?

617


Explain the use of containers in ssis?

538


what is a schema in sql server 2005? : Sql server database administration

523


What is difference between foreign key and unique key?

560


Explain “@@rowcount” and “@@error” in sql server?

547


How many instances per computer are there in sql server 2000?

590


Explain the first normal form(1nf)?

567