InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Union? |
|
Answer» Join is DATA retrieval operation that combines multiple query outputs of the same structure into a single output. By default the MySQL UNION removes all duplicate rows from the result set even if you don’t explicit using DISTINCT after the keyword UNION. SELECT customerNumber ID, contactLastname name FROM customers UNION SELECT employeeNurrber id, firstname name FROM EMPLOYEESid name 103 Schmitt
Join is data retrieval operation that combines multiple query outputs of the same structure into a single output. By default the MySQL UNION removes all duplicate rows from the result set even if you don’t explicit using DISTINCT after the keyword UNION. id name 103 Schmitt
|
|