What is the difference between join and union.

Answer Posted / nand kumar

Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.

Is This Answer Correct ?    124 Yes 52 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view output in sql developer?

565


Explain dml and ddl?

533


Can we call procedure in select statement?

510


Can I learn sql in a week?

537


Are pl sql variables case sensitive?

586






What is acid property in a database?

574


How do I find sql profiler?

501


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

676


discuss about myisam key cache. : Sql dba

558


What is AUTH_ID and AUTH_USER in pl/sql ?

1678


What are triggers in sql?

574


What is sqlservr exe?

474


What is cartesian join in sql?

548


what is cross join? : Sql dba

560


Can we alter stored procedure?

533