compare two tables count the replies and display in asp.net
i have an two table question ,replies in asp.net using sql server 2005 ,if i got reply for that question,replies are added to the reply table in question table i specify that that id are auto increment so, i want to specify the number of replies for each questions,
give any ideas to do this,
Thank u,