I Have a dataset containing 2 tables, 1 of suppliers and 1 of products i stock. how can i link the 2 tables so that instead of seing a supplierID number it tells me the supplier name?
Example
SELECT Products.*, SUpplier.Name
FROM Products
INNER JOIN Supplier ON
Products.SupplierID = Supplier.SupplierID
This will join the products and supplier tables together and display the product fields and the supplier name from the supplier table where there is a match between then Product table supplierID and the Supplier table SupplierID.
