Posted: Tue Jul 20, 2004 1:32 pm
insert into album_category (Category_ID, Title) values (1, 'cat1');
insert into album_category (Category_ID, Title) values (2, 'cat2');
insert into album_category (Category_ID, Title) values (3, 'cat3');
insert into album_category (Category_ID, Title) values (4, 'cat4');
insert into album_category (Category_ID, Title) values (5, 'cat5');
insert into photo_album (Album_ID, Category_ID) values (1, 1);
insert into photo_album (Album_ID, Category_ID) values (2, 2);
insert into photo_album (Album_ID, Category_ID) values (3, 1);
insert into photo_album (Album_ID, Category_ID) values (4, 3);
insert into photo_album (Album_ID, Category_ID) values (5, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (1, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (2, 2);
insert into photo publishable_item (Item_ID, Submitter_ID) values (3, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (4, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (5, 2);
when I would like to see the info on the categories for submitter 1 I should get:
I hope this helps
insert into album_category (Category_ID, Title) values (2, 'cat2');
insert into album_category (Category_ID, Title) values (3, 'cat3');
insert into album_category (Category_ID, Title) values (4, 'cat4');
insert into album_category (Category_ID, Title) values (5, 'cat5');
insert into photo_album (Album_ID, Category_ID) values (1, 1);
insert into photo_album (Album_ID, Category_ID) values (2, 2);
insert into photo_album (Album_ID, Category_ID) values (3, 1);
insert into photo_album (Album_ID, Category_ID) values (4, 3);
insert into photo_album (Album_ID, Category_ID) values (5, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (1, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (2, 2);
insert into photo publishable_item (Item_ID, Submitter_ID) values (3, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (4, 1);
insert into photo publishable_item (Item_ID, Submitter_ID) values (5, 2);
when I would like to see the info on the categories for submitter 1 I should get:
Code: Select all
category_ID Title NumAlbums
1 cat1 2
2 cat2 0
3 cat3 1
4 cat4 0
5 cat5 0