relational-record-examples-0.2.0.0: sql/5.3a.sh
#! /bin/bash # Self-join sqlite3 exmaples.db " SELECT e.fname, e.lname, e_mgr.fname mgr_fname, e_mgr.lname mgr_lname FROM employee e INNER JOIN employee e_mgr ON e.superior_emp_id = e_mgr.emp_id ;"
#! /bin/bash # Self-join sqlite3 exmaples.db " SELECT e.fname, e.lname, e_mgr.fname mgr_fname, e_mgr.lname mgr_lname FROM employee e INNER JOIN employee e_mgr ON e.superior_emp_id = e_mgr.emp_id ;"