yes! i've already given you the query based on the tables / columns you provided. just run the query (forget about creating the proc for a minute) and see if it gives you the result? if not then post the error message etc (as i asked you to earlier)
Oh! i'm so bad Coz i forget to bind UserName field in design view and i always try to modify in codeview and sql query. Now i'm really ok with your query. Thanks alot elancaster.