In join we use ON clause rather than where clause so where is not used mos

In join, which clause in not used?

Question Posted / murtaza

Answer Posted / murtaza

In join we use ON clause rather than where clause
so where is not used most probably in joins.
and order clause is also not used .

Is This Answer Correct ?

4 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What do you understand by coalesce in sql server?

999

Write the syntax for stuff function in an sql server?

976

List the advantages of using stored procedures?

996

What new changes are being made in SQL Server?

1093

Do you know spatial data types - geometry and geography in sql server 2008?

968

Define ACID properties in a Database?

1002

Explain the difference between primary keys and foreign keys?

942

What is TDS(Tabular Data Stream) Gateway?

121

How to change the name of a database user?

907

How to make remote connection in database?

953

What is attribute hierarchy? : sql server analysis services, ssas

960

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

890

What is instead of dml trigger?

946

What is join query?

836

How do I know if localdb is running?

890