Join (Natural Join)

SELECT Product? ProdID, Product? ProdDesc, Supplier? SupplierName

FROM Product, Supplier

WHERE Product? SupID = Supplier? SupplierID

Table names required in Select statement only if there’s a possibility of ambiguity

Previous slide

Next slide

Back to first slide

View graphic version