Explain how to combine queries using the UNION clause. What ...

[geoffrey]

Explain how to combine queries using the UNION clause.
 
  What will be an ideal response?

Question 2

Validation can protect against SQL injection attacks.
 
  Indicate whether the statement is true or false.

[aburgess]

Answer to Question 1

The UNION clause is used to combine the output of multiple queries into one set of output. In order for the union to work, each query must return the same number of columns. Also, each output column must be union compatible, meaning it is of the same type. The CAST command can be used to convert from one datatype to another if need be. If you wish to order the output rows, you must specify an ORDER BY clause in the last query.

Answer to Question 2

Answer: TRUE