ASP VB and Access. I am struggling with inner joins!
Currently, I am trying to replace a number in my main table with
the number that it relates to in another table... as you would
expect an inner joint to do!
I have two tables.
The first table is 'Manufacturers' with the columns of
ManufacturerID and ManufacturerName
The second table is 'Products' with a column of ProductID,
ManufacturerID, ProductName and many more not so relevant to this
requirement.
I need to get the number in Products.ManufacturerID to be
replaced by Manufacturers.ManufacturerName when it is read into a
browser.
I am sorry to be so blatant, but what is the sql for this? I
just can't figure it out! It's gone 3 a.m. and I am at the end of
my tether!
Here's one example that I have attempted, but nothing is
working:
SELECT Manufacturers.Manufacturer, Products.ManufacturerID
FROM Manufacturers INNER JOIN Products ON
Manufacturers.Manufacturer = Products.ManufacturerID"
I hope somebody can help me. I am sooo stuck...
Many thanks.
Mat