Union clause

• Way of combining data from multiple queries

• Uses the column names from the first SELECT statement

select fname FirstName, lname LastName, city City from authors where city=‘Oakland’UNIONselect fname, lname, cityfrom authors where city=‘New York’

Previous slide

Next slide

Back to first slide

View graphic version