HI thx for your reply,

i have treid you code but get error:

SELECTP.patno, P.name, P.docno, d.lname, d.specialization, COALESCE( T.NoOfTreatments, 0 ) AS NoOfTreatments

*

ERROR at line 1:

ORA-00918: column ambiguously defined.

any thoughts, thank...