Posted by JJ297 on 08/24/07 16:30

Having problems joining three tables. I only want the Title field but
need them to give me the correct data.

Here are my three tables and their fields.

1. Titles
TitleID
Title
[description]


2. Classifications
ClassificationID
[Description]

3. Titleclassification
ClassificationID
TitleID

This is my stored procedure thus far but getting incorrect syntax
error.

select Titles.Title

>From Titles

Inner Join Titleclassification on classifications.classificationid =
titleclassification.classificationid
Join titlecassification.titleid = titles.titleid

[Back to original message]