INNER JOIN grief

I thought it worked, but it didn't, well, not quite! It bought in a manufacturers name, but only the one that was first in the manufacturers table.

I also had a go at Jules' drag n drop suggestion, but that had pretty much the same effect - it only bought in the first manufacturer name in the table!

I don't know why it is so difficult, but all I need to do is replace the number in the product table that corresponds to the name of the manufacturer in the manufacturers table!

Has anyone got any other ideas?

Thanks.

Mat

This can all be done in Access using their drag'n'drop tools. Create a new
query and away you go.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:fi178h$fia$1@forums.macromedia.com...
> Yes! Excellent! That did the job, but it has left me in complete confusion
> now.
>
> In order to take a reference from one table that was simply a number and
> replace it with text from another table that is related to that column, I
> thought you had to use a JOIN.

No you aren't replacing anything,
you select the text value from the other table where that other table
contains a numeric column with the same value as the numeric column in first
table.

> My first forey into a JOIN statement and I have fallen at the first
> hurdle -
> not understanding when to use JOIN! Is there any info on JOIN statements
> that I
> can learn from. I have looked on the web and I have found examples of how
> to do
> a join, but not how or when to use them. Would it be easy to explain here,
> or
> would that be a long job?

You use a join when you want to return data from multiple tables that have
values that can be correlated in some way expressible in SQL.

> Thanks for your reply anyway.
>
> Mat

Yes! Excellent! That did the job, but it has left me in complete confusion now.

In order to take a reference from one table that was simply a number and replace it with text from another table that is related to that column, I thought you had to use a JOIN.

My first forey into a JOIN statement and I have fallen at the first hurdle - not understanding when to use JOIN! Is there any info on JOIN statements that I can learn from. I have looked on the web and I have found examples of how to do a join, but not how or when to use them. Would it be easy to explain here, or would that be a long job?

Thanks for your reply anyway.

Mat

All your wanting to do is show the Manufacturers.ManufacturerName & Products.ManufacturerID?

"SELECT Manufacturers.Manufacturer, Products.ManufacturerID FROM Manufacturers, Products WHERE Manufacturers.ManufacturerID = Products.ManufacturerID"

Wouldnt that do the job?