SQLize | PHPize | SQLtest

CREATE TABLE Customers( ID INT, Name VARCHAR(50), City VARCHAR(50) ); CREATE TABLE Orders( ID INT, CustomerID INT, Amount INT ); INSERT INTO Customers VALUES (1,'Muskan','shamli'), (2,'Vaishnavi','Bahjoi'), (3,'Ankit', 'Gurgoan'), (4, 'Reema', 'Hathras'); INSERT INTO Orders VALUES (1, 1, 1000), (2, 2, 500), (3, 3, 1200), (4, 5, 600); SELECT*FROM Customers; SELECT*FROM Orders; SELECT Customers.Name, Customers.City, Orders.Amount FROM Customers INNER JOIN Orders ON Customers.ID = Orders.CustomerID; SELECT Customers.Name, Customers.City, Orders.Amount FROM Customers LEFT JOIN Orders ON Customers.ID = Orders.CustomerID; SELECT Customers.Name, Orders.Amount FROM Customers RIGHT JOIN Orders ON Customers.ID = Orders.CustomerID; SELECT Customers.Name, Orders.Amount FROM Customers FULL OUTER JOIN Orders ON Customers.ID = Orders.CustomerID;