Problem with my join query
I am setting up my Data Assist Details page and in my database "product" table I have field entitled "QualityID" this field is the reference for the product's quality types. The "quality" table has the following two fields that the product table is referencing: "QualityID" and a "QualityName" field.
On my details page it is showing the "QualityID"( i.e., "2") number, however I want show the actual "QualityName" (i.e., "Eclipse") that it references . How do I accomplish this? I tried the code below however it only shows me the name from the first QualityID ignoring the that is should be should the name from the second QualityID.
Here is the code I used. Am I missing something?
SELECT product.*, quality.QualityName
FROM product INNER JOIN quality ON product.QualityID = quality.QualityID