What is the difference between JOIN and UNION? database join sql union What is the difference between JOIN and UNION? Can I have an example?