sql server 2008 - how fiter the values when joining 4 tables? -

tbl_category

pk_int_category_id, vchr_category_name 

tbl_projects

fk_int_category_id, pk_int_project_id, vchr_project_name, vchr_project_description, bln_project_status 

tbl_project_album

pk_int_album_id fk_int_project_id vchr_album_name vchr_album_description 

tbl_picture

fk_int_album_id, pk_int_picture_id, vchr_picture_name, vchr_picture_description, vchr_picture_path 

insert data tables 2 categories c1 , c2, enter 2 or 3 projects, corresponding each category. c1p1, c1p2, c2p1, c2p2 , on. there should minimum 2 albums per project , minimum 2 pictures per album

1. create result set containing:
   

   pk_category_id,
   category_name,
   pk_project_id,
   project_name,
   pk_picture_id,
   picture_name,
   pk_album_id,
   album_name
   

2. filter result set in such way projects and, albums , 1 picture corresponding album displayed

3. filter result set in such way projects and, 1 picture , 1 album corresponding project displayed

select c.pk_int_category_id ,c.vchr_category_name,p.pk_int_project_id,p.vchr_project_name,pr.pk_int_picture_id,pr.vchr_picture_name,a.pk_int_album_id,a.vchr_album_name tbl_category c,tbl_projects p,tbl_project_album a, tbl_picture pr c.pk_int_category_id=p.fk_int_category_id , p.pk_int_project_id=a.fk_int_project_id , a.pk_int_album_id=pr.fk_int_album_id;