What is the difference between join and union.

Answer Posted / thangamadasamy

A join selects columns from 2 or more tables. A union
selects rows

Is This Answer Correct ?    123 Yes 63 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is error ora-03113: end-of-file on communication channel?

597


What is compiled query?

516


What are stored procedures in mysql?

555


What is the difference between microsoft access and sql?

495


what are the security recommendations while using mysql? : Sql dba

576






How do I view tables in sql developer?

510


What are the differences between in and exists clause?

563


What are the two characteristics of a primary key?

483


What is left join in postgresql?

532


How can you load multi line records? : aql loader

653


Can a table have no primary key?

550


What is a delimiter in sas?

541


How do I truncate a sql log file?

528


What is an example of translating a date into julian format?

573


Does sqlite need a server?

535