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

How to get the definition of a view out of the sql server?

971

New concepts of sql server 2005 use in your project.

2345

What are binary string data types in ms sql server?

1253

What is set nocount on and what is set nocount off?

924

How you can find out if an index is useful to the optimizer?

920

What is mssql?

973

Detail about query optimizer?

1079

How do I create a stored procedure in dbml?

987

When would you use the stored procedures or functions?

987

Can we take the full database backup in log shipping?

930

Which are the important points to note when multilanguage data is stored in a table?

970

Explain few examples of stored procedure over triggers?

1010

Explain in details security in SQL azure?

121

Why should we go for stored procedures? Why not direct queries?

1068

How can we delete a table in sql server?

955