mysql同时查询三张表的问题

[FVG55]

数据表
users有字段uid,b,c
orders有字段oid,uid,e
products有字段pid,uid

现在要将users所有查询出来，并且统计每个users的uid在orders表中的个数和products中的个数，我这样写的
select users.uid,count(orders.uid),count(products.uid) from users,orders,products where users.uid=orders.uid and users.uid=products.uid
可是这样查询的话，如果users用户在orders或products没有记录的话，这个users就没被查询出来，我的目的是就算没有记录，也要查询出来，显示0即可。请问要怎么改？

[道玄希言]

select  T1.uid, ifnull(T2.uid, 0),  ifnull(T3.uid, 0) 
from  users as T1
left join (select count(uid) as uid from orders group by uid) as T2
on T1.uid =T2.uid
left join ((select count(uid) as uid from products group by uid) as T3
on T1.uid =T3.uid

[ACMAIN_CHM]

这个不能使用JOIN查询，会造成重复。

select uid,
	(select count(*) from orders where uid=users.uid),
	(select count(*) from products where uid=users.uid)
from users