SQL - INNER JOIN
Consider these tables:
ProductID | Name
1 | Pen
2 | Pencil
ProductID | Quantity
1 | 10
3 | 5
What will this query return?
ProductsProductID | Name
1 | Pen
2 | Pencil
SalesProductID | Quantity
1 | 10
3 | 5
What will this query return?
SELECT Products.Name, Sales.Quantity FROM Products INNER JOIN Sales ON Products.ProductID = Sales.ProductID;