CODEWITHSUNDEEP
sqlsql-server
bluesky
bluesky

Reputation: 646

sql server issue with inner join

I currenlty have this code

SELECT JOB.JobID, A.adID, AR.ARNum
FROM dbo.vEvent AS E, dbo.[vAd] as A, dbo.[vAR] as AR, dbo.JOB_EVENT as JOB
INNER JOIN A ON A.eventID = E.eventID
INNER JOIN AR ON AR.eventID = A.eventID
INNER JOIN JOB ON JOB.EVENT_ID = E.eventID
WHERE year = '' AND season = '' AND month = ''

however; when I execute it in SQl server I get this error. 

Msg 208, Level 16, State 1, Line 1
Invalid object name 'A'.

I don't understand, because all of my variables look correct to me.

Any help would be appreciated.

Upvotes: 0

Views: 228

Answers (1)

Matt Whitfield
Matt Whitfield

Reputation: 6574

You want

SELECT JOB.JobID, A.adID, AR.ARNum
FROM dbo.vEvent AS E
INNER JOIN dbo.[vAd] as A ON A.eventID = E.eventID
INNER JOIN dbo.[vAR] as AR ON AR.eventID = A.eventID
INNER JOIN dbo.JOB_EVENT as JOB ON JOB.EVENT_ID = E.eventID
WHERE year = '' AND season = '' AND month = ''

Upvotes: 5

Related Questions