relational-record-examples-0.2.0.0: sql/6.4.1a.sh

#! /bin/bash

#Sorting compound query results

sqlite3 examples.db "
SELECT emp_id, assigned_branch_id
FROM employee
WHERE title = 'Teller'
UNION
SELECT open_emp_id, open_branch_id
FROM account
WHERE product_cd = 'SAV'
ORDER BY emp_id
;"