Required Query for Counting

Hello Experts, DAVEY23UK,

Required Query for Count

I was struck up with writing a query my scenario is ...

Customer details table :
Cno,Cname, ....... (fields)

Product details table :
Pno,pname .....Cno (fields where Cno refers to cno of customer)

Cheques details table :
chqno, .....(Cno) (fields where Cno refers to cno of customer)

there is no direct relation or bependency between product and cheques table.

I need to write a single query "without nesting" we can have union, such that the output is like this :

Cno products cheques
2...........13...........5
5...........2............89
9...........11...........2


which mean it should display customer number, his purchase of total number of products, his total number of cheques issued..

somebody help me with this, I was struck up in my work with this

Thanks in advance,
Regards,
Sai.k.k.

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