I have two tables named categories and products, structure of tables is like below:

Categories(category_id,category_name)

1, ajax
2, adobe
3, software dev
4, database

products(product_id,product_name,category_id)

1, dbbooks, 4
2, software practice, 3
3, dreaviewver, 3
4, hide-show, 1

This is sample reults, Result should display like this:
1 ajax(1)
2 adobe(0)
3 software dev(2)
4 database(1)
I shall be very thankful...........Please help me....... Suresh

I have two tables named categories and products, structure of tables is like below:

Categories(category_id,category_name)

1, ajax
2, adobe
3, software dev
4, database

products(product_id,product_name,category_id)

1, dbbooks, 4
2, software practice, 3
3, dreaviewver, 3
4, hide-show, 1

This is sample reults, Result should display like this:
1 ajax(1)
2 adobe(0)
3 software dev(2)
4 database(1)
I shall be very thankful...........Please help me....... Suresh

let me give you three hints:

1, LEFT OUTER JOIN
2, COUNT()
3, GROUP BY

i have toagree