What is the difference between join and union ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the difference between join and union ?

Join is used to retireve data from different tables using a single SQL statement. Union is used to combine the results of two or more SQL queries.

(Continued on next question...)

Other Job Interview Questions

• How do you define a correlated name ?
• What is the best lock size that you could use when you create a tablespace?
• When is the access path determined for dynamic SQL?
• What is an inner join, and an outer join?
• What is a synonym?
• What does DML stand for and what are some examples of it?
• DB2 can implement a join in three ways using a merge join...
• Can I use LOCK TABLE on a view?
• Which DB2 command is used to retireve environmental information?
• What is the name of the default DB2 catalog database ?
• More...