select p.PhotoID,p.Name,u.Userid,u.Name
from photo p,user u
where p.Userid = u.p and Userid IN (
select Userid, count(ownerid)
from photo
group by Userid
having count(Userid) >= 1
);作者: renxiao2003 时间: 2011-01-04 20:05
where p.Userid = u.p and Userid IN (
u.p,请问P在哪里,UserId是那个的UserID作者: hg70hg70 时间: 2011-01-04 21:37
select p.PhotoID,p.Name,u.Userid,u.Name
from photo p,user u
where p.Userid = u.Userid and p.Userid IN (
select Userid, count(ownerid)
from photo
group by Userid
having count(Userid) >= 1
);