SESSION NAME: Data Sorting.

QUESTION NAME: Union ALL - Query Ascending.


TABLE DESCRIPTION:
The "customers" table has following field

1. customerid
2. firstname
3. lastname
4. city
5. state

The "suppliers" table has following field

1. SupplierID
2. SupplierName
3. ContactName
4. Address
5. City
6. PostalCode
7. Country
8.Phone


Write a query to display city from customers tables and suppliers table using "UNION ALL" clause.

The final resultant should be in Ascending order.

CODE:
select CITY from CUSTOMERS UNION ALL select CITY from SUPPLIERS order by CITY asc;