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