Hi David Burrows,

Thank you so much for your reply.

Its working....................... :w00t: :hehe:

We are getting result like this:

T_ID Teacher_Name Appr_ID Approver_NAME

15122 Peter Beechen 1 tess tsssss

15122 Peter Beechen 2 yamini baratam

15122 Peter Beechen 3 Moulika buragadda

16678 Samantha Smith 2 yamini baratam

16679 Matthew...