Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
 | 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. They are: 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 and select decode(COMMITTEE_MEMBER_T.FacultyID,COMMITTEE_MEMBER_T.ChairPerson,'Y') chair from COMMITTEE_MEMBER_T …  |