"Lovely Angel For You" <lovely_angel_for_you@yahoo.com> wrote in message
news:55295a7e.0306280821.35cdd9ed@posting.google.c om...
> Dear Friends
> Hope you all doing great.
>
> I have been working on a project (lots of previous queries) which
> requires me to organize articles in certain manner.
> I am working with Access 2000 and ASP.
>
> I used three tables
>
> Table one stores the info about Main Categories
> Table two stores the info about Sub categories
> Table three stores the actual article.
>
> Table One
>
> Name-----------ID
> Science---------1
> Maths----------2
> English---------3
>
> Table Two
> Name----------ID---------MainID
> Chemistry------1----------1
> Physics--------2----------1
> Algebra---------3----------2
> integration------4---------2
> grammer---------5----------3
>
> Table Three
> Article----------ID----------SubID
> data----------1--------------1
> data-----------2-------------5
> data-----------3-------------4
> data-----------4-------------5
> data-----------5-------------5
> data-----------6-------------3
>
> And so on
>
> Now I want to count total number of articles under MainID
>
> Total Articles Of Science ------------- 1
> Total Articles Of English--------------3
> Total Articles Of Maths---------------2
>
> I worked on logic but as I am weak on SQLQuery I am asking for your
> help.
>
> Find the number of articles corresponding to ALL SubCategories
> Corresponding to selected MainCategory.
>
> Hope you got the idea what I want.
>
> Waiting for your reply.
>
> Love
> Lovely
>
Joins are well explained at [url]www.w3schools.com/sql/sql_join.asp[/url] - hope this
helps

cm