SELECT ( SELECT `NAME` FROM Account WHERE AccountId=StudentId ) AS STUDENTNAME, ( SELECT `NAME` FROM Account WHERE AccountId=TutorId ) AS TUTORNAME FROM Appointment
select (select NAME from ACCOUNT where ACCOUNTID=a.STUDENTID) as STUDENTNAME, (select NAME from ACCOUNT where ACCOUNTID=a.TUTORID) as TUTORNAME from APPOINTMENT a
(
SELECT `NAME`
FROM Account
WHERE AccountId=StudentId
) AS STUDENTNAME,
(
SELECT `NAME`
FROM Account
WHERE AccountId=TutorId
) AS TUTORNAME
FROM Appointment
(select NAME from ACCOUNT where ACCOUNTID=a.STUDENTID) as STUDENTNAME,
(select NAME from ACCOUNT where ACCOUNTID=a.TUTORID) as TUTORNAME
from APPOINTMENT a