Apart all the joins above there is one more join it is NO EQUI JOIN ie

How many types of Joins in SQL Server 2005?

Question Posted / kalyana chakravarthy maddipati

Answer Posted / kalyana chakravarthy maddipati

Apart all the joins above there is one more join it is

NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define synonym?

1154

Can sql server 2016 run on windows 7?

902

How do I view a trc file?

924

How does Report Builder support Analysis Services cubes?

153

What is the data type of time?

954

What is deploy, process and build? : sql server analysis services, ssas

1084

How do you improve the performance of a SQL Azure Database?

137

How to verify a login name with sqlcmd tool?

1195

What methods do you follow to protect from sql injection attack?

1002

Will sql server 2005 allow you to reduce the size of a column?

967

How to provide default values to function parameters?

1108

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2195

What will be query used to get the list of triggers in a database?

984

What is meant by referential integrity?

995

How to create database with physical files specified in ms sql server?

979