select c.cno customer,count(distinct p.pno) products,count(distinct ch.chno)
from customers c,products p,cheques ch
where c.cno=p.cno and c.cno=ch.cno
group by c.cno
PLEASE TEST CAREFULL!!! Not sure if it is exactly what u need
|
Results 1 to 2 of 2
Thread: Required Query for CountingThreaded View
|
Click Here to Expand Forum to Full Width |