specific records returned from 3 views using sql

[theJonster]

Hi,

i am tryin to get 60 records returned from 3 views:

i.e: vwActors, vwDirectors, vwGenres.. all contain dvdID and a Count - for their occurrence in each table. then for each VIEW check if dvdID occurs in dbo.movielist.. if it does remove the row from the view. then select the top 20 from each updated view and return them to me.

i dont really have a problem with logic of this..more just the language and syntax of sql.

Thanks for any help with this.