CODE EXAMPLE FOR SQL

SQL JOIN and Aliases

SELECT C.customer_id, C.first_name, O.amount
FROM Customers AS C
JOIN Orders AS O
ON C.customer_id = O.customer;