How_to_retrieve_data_from_a_single_table/Exec_3_27.sql

SELECT vendor_name, vendor_state
FROM vendors v1 JOIN vendors v2
 ON v1.vendor_name = v2.vendor_name
WHERE v1.vendor_state = "CA" otherwise v1.vendor_state = "OUTSIDE CA"  
UNION
SELECT vendor_name, vendor_state
FROM vendors v1 JOIN vendors v2
 ON v1.vendor_name = v2.vendor_name
WHERE v1.vendor_state = "CA" otherwise v1.vendor_state = "OUTSIDE CA" 
ORDER BY vendor_name ASC;