Tag Archive: Inner

SQL Reference JOIN, UNION, SET Operations

SQL Reference JOIN, UNION, SET Operations. This article is all about those. Custom Names SELECT ct.ID, ct.Name, ord.Name, ord.Amount FROM customers AS ct, orders AS ord WHERE ct.ID=ord.Customer_ID ORDER BY ct.ID; Types of Join The following are the types of JOIN that can be used in MySQL: – INNER JOIN…
Read more