Problem in sql query
- by Vishwa
Hi
I have 2 tables Order and orderDetails table...
I have written a inner join
SELECT Order.id
FROM Order
INNER JOIN orderDetails
ON Order.id=orderDetails.id
I have got the output as
id
100
100
100
101
101
from the above data i want the count of each record
OUTPUT AS :
id count
100 3
101 2
help me i am new to sql