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

Thank you for you help!

dgerbergss,

Have a look here, it is from MySQl website and shows how to nest queries

What is the relation between the following tables ?

STUDENT_T, FACULTY_T

COMMITTEE_MEMBER_T

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.