Join (SQL),”Joins allow you to link data from two or more tables together into a single query result–from one single SELECT statement.Forms relationships between tablesex. SELECT customer_info.firstname, customer_info.lastname, purchases.itemFROM customer_info
purchasesWHERE customer_info.customer_number = purchases.customer_number;”