Newbie here. Having trouble with a multi-table join exercise, code below. A two-table join works fine but more than that produces this error:
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'vt_exam_details'.
Every query with 3 or more tables produces this error on the second joined table. I'm running 2008R2 on Windows 7.
vt_animals as A
vt_exam_headers as EH on (A.an_id = EH.an_id)
vt_exam_details as ED on (EH.ex_id = ED.ex_id)
vt_services as S on (ED.srv_id = S.srv_id)
A.an_type in ('rodent')