select *, d.UNITID, d.INLAW, d.OUTLAW from DIRINFO as d left join COAOFFICIAL as t 
				on d.UNITID=t.UNITID and d.TYEAR=t.YEAR where INSTURL IN ("james-e-rogers-college-of-law", "university-of-new-mexico-school-of-law") order by d.UNITID