Dear Sean!

Your code is so simple but it very excellent.

It solved all my problem

Thank you so much

Dear all

Thank you all for spending your time in this topic, and now, i've finished this problem by following code:

select distinct [Subject].SubName, Marks.Mark from Marks

inner join [Subject] on Marks.SubID=[Subject].SubID...

Jonh!

Thank for your attention in this, but would you like to show me how more clearly?

I am a newbie in this language.