What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?

Answer Posted / jitendra mali

The equi join is retrived selected column from the both
the table
or
The inner join is only retrived selected column from the table

Is This Answer Correct ?    6 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you name some of the dml commands in sql?

754


How to use values from other tables in update statements in ms sql server?

742


What is ddl command?

701


Explain how many types of relationship?

757


what is the sql equivaent of the dataset relation object ?

1727






What is the use of =,==,=== operators?

770


Give me any three differences between Truncate and Delete.

759


What are the advantages of user defined function?

663


What is sub query and its properties?

735


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?

707


How to use column default values in insert statements in ms sql server?

718


What is the use of group by clause?

708


What are the purpose of Normalisation?

800


How do you check sql server is up and running?

690


Do you know what are the restrictions that views have to follow?

822