1

HI, for your first question try with the following
SELECT D.initials || D.surname as DoctorName, Pe.initials || Pe.surname as Personnam, Pe.membership_number As membername FROM DOCTOR D, MEMBERSHIP M, PERSON PE,
PROVIDED_SERVICE PS
WHERE
PE.membership_number = M.membership_number AND
PE.person_number = PS.person_number AND
D.doctor_number = ps.doctor_number ;

can you give me some detail description for your second question.

Chalam N

1