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 are the disadvantages of merge replication?

1424

wat wil hapn if we give the both read and deny read permission to user?

2104

How to convert a numeric expression from one data type to another?

1023

How to invoke a trigger on demand?

1096

How to delete all rows with truncate table statement in ms sql server?

1006

How to list all columns in a table using odbc_columns()?

977

Explain acid?

1089

What is explicit mode in sql server?

1068

What are the disadvantages of using querystrings to send data from one page to another?

1008

Can foreign key be deleted?

930

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

982

what are the different ways to return the rowcount of a table?

1003

Tell me what is normalization? Explain different forms of normalization?

1033

Explain about temporary stored procedure?

1032

What is difference between rownum and rowid?

910