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

• Next in forum: Re: Convert CHAR YYYYMMDD to mm/dd/yyyy
• Prev in forum: Restore sql server express bak file as different db?
• Thread view: Trying to join three tables

[Reply to this message]