Toad World® Forums

Error: Invalid relational operator

Hello! I am new to the Community. The smart folks have not arrived in the office yet. So, I can’t figure out why I am getting the ‘invalid relational operator’ error at WHERE.

Below is my select. Help. In advance, Thank you!

select
t.setid,
E.INSTITUTION_NAME,
t.award_term,
t.student_id,
t.student_inst_id,
t.degree_acronym,
t.inst_major_code

from usgrds.rds_awards t

left join USGEDW.EDW_USG_INSTITUTION_LKP_NEW e
on t.setid

where T.SETID = ‘73000’
and T.AWARD_TERM in (‘20171’,‘20172’,‘20174’)

order by award_term, degree_acronym, inst_major_code

I got it!

I failed to complete this line:

left join USGEDW.EDW_USG_INSTITUTION_LKP_NEW e
on (t.setid=e.setid)