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

What is the function that is used to transfer a pl/sql table log to a database table?

557


What is schema in sql?

518


How do I save the results of sql query in a file?

540


how do you know the version of your mysql server? : Sql dba

510


What is a sql driver?

532






How do you write an index?

531


Where the sql database files are stored?

500


What is an exception in PL/SQL? What are the two types of exceptions?

633


how does a local variable is defined using t-sql? : Transact sql

550


Explain the types of joins in sql?

575


what are aggregate and scalar functions? : Sql dba

555


What is the process of debugging?

559


Which nosql database is best?

519


What is the example of procedure?

525


What is cursor explain with example?

562