SQL - Database Programming Language
This course covers the basics of working with SQL. Work your way through the videos/articles and I'll teach you everything you need to know to interact with database management systems and create powerful relational databases!


Lesson 16
Author : 🦒
Last Updated : December, 2017


Copy-- Find a list of employee and branch names
SELECT employee.first_name AS Employee_Branch_Names
FROM employee
SELECT branch.branch_name
FROM branch;

-- Find a list of all clients & branch suppliers' names
SELECT client.client_name AS Non-Employee_Entities, client.branch_id AS Branch_ID
FROM client
SELECT branch_supplier.supplier_name, branch_supplier.branch_id
FROM branch_supplier;