help with a query

hello,

I'm going crazy trying to figure this out:

1. I have 2 tables named videos and channels
2. Foreign key is Channel_ID where I store the id of the channel the video belongs to
3. Relevant fields for table videos are: Video_ID, Video_PostedOn, Channel_ID
4. Relevant fields for table channels are: Channel_ID, Channel_Name

I need to get the 3 most recent videos for each Channel_ID currently present in the videos table, ordered by Channel_Name ASC.

I would really appreciate it if someone could help me out with this. maybe r937?

thanks in advance