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)