Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kituscat
Starting Member
1 Post |
 Posted - 2009-03-08 : 18:04:20
|
| Hi everybody,i need some help. I have 3 tables categories (from which i extract the items of the menu), subcategories and products. I'd like to show the items of the menu and, beside, the number of products in each category. Maybe it's very easy but it's still hard for me to figure out some queries...thanks ... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-08 : 18:06:26
|
| Learn how to post:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 02:59:18
|
| seems like its a simple join what you want. but as told earlier, you have not given us much info. so post some data as requested and then explain |
|
|
|
|
|
|
show the items of the menu and the number of items