Posted by Roy Harvey (SQL Server MVP) on 10/24/07 15:50

Without DDL for all the tables, including all keys, all I can do is
guess. In this case I guessed that the titleclassification table
includes titleid, and that the key is (titleid

SELECT A.titleid,
A.title,
A.[description],
B.quantityowned,
classifications.[description]
FROM Titles as A
JOIN resources as B
ON A.titleid = B.titleid
JOIN titleclassification as C
ON A.titleid = C.titleid
JOIN classifications as D
ON D.classificationid = C.classificationid

Roy Harvey
Beacon Falls, CT

On Wed, 24 Oct 2007 08:42:09 -0700, JJ297 <nc297@yahoo.com> wrote:

> I'm need to get the [description] from the classifications table
>Trying to join it to another table (titleclassification) but I don't
>need info from that table. I'm getting the results but it's sending
>back repeat data. Any suggestions?
>
>SELECT
> Titles.titleid, titles.title, titles.[description],
>resources.quantityowned, classifications.[description]
>
> FROM
> Titles inner join resources on titles.titleid = resources.titleid,
>classifications inner join titleclassification on
>classifications.classificationid =
>titleclassification.classificationid
>
>Thanks so much!

[Back to original message]