|
|
Posted by JJ297 on 10/24/07 15:42
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!
Navigation:
[Reply to this message]
|