Hey there I have two separate queries and I am trying to figure out how to combine them into one. I've verified separately each one works.
SELECT FACULTY_t.LastName||', '||FACULTY_T.FirstName AS "Committee", STUDENT_T.LastName||', '||STUDENT_T.FirstName AS "Student"
FROM STUDENT_T, FACULTY_T
Where STUDENT_T.CommitteeID = FACULTY_T.FacultyID
select decode(COMMITTEE_MEMBER_T.FacultyID,COMMITTEE_MEMBER_T.ChairPerson,'Y') chair
Thank you for you help!