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 function does a database engine serve in the sql server?

664


What does man by sql wildcard characters in sql server?

620


Can we shrink data file in sql server?

628


What is NOT NULL Constraint in sql server 2012?

672


Can we use having clause without group by?

644






What is after dml trigger?

663


When I run the sql server 2000 setup, it just hangs. What do I do?

723


Do you know how to store and query spatial data?

683


How can delete duplicate records in cte in sql server?

610


What is model database? : SQL Server Architecture

661


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

650


what is nonclustered index

624


Can a cursor be updated? If yes, how you can protect which columns are updated?

612


Is it possible to have clustered index on separate drive from original table location?

608


What is the difference between dataadapter and datareader?

617