我这个sql语句哪里错了啊？

[hongcha99]

select distinct a.*,b.Name,b.YM from T_InsideInfo as a,T_Personnel as b where a.PID=b.PID and a.InID = '2d8b3586-f98b-4b55-bd0b-de1950bf1ee9' and a.IsDelete=0 order by a.CreateTime desc

关键在于我要查出b.name,b,ym现在问题在于，a表里面有一条数据，B表里面有两个人所以我查出来结果如下：

2012-08-15 08:48:56 2 0 杜鹏 peng.du
2012-08-15 08:48:56 2 0 刘志忠 liuzhzhong

如果我改成：select distinct a.*,b.Name,b.YM from T_InsideInfo as a,T_Personnel as b where a.PID=b.PID and a.InID = '2d8b3586-f98b-4b55-bd0b-de1950bf1ee9' and a.PersonID=b.PersonID and a.IsDelete=0 order by a.CreateTime desc

则一条数据都出不来了。

我要的结果是：2012-08-15 08:48:56 2 0 杜鹏 peng.du

该怎么写啊？

[不訴離傷]

a.PersonID=b.PersonID 你确定你要的资料的PersonID都符合要求吗，你把他们都打印出来看看。是不是一样的。

[bdmh]

a.PersonID=b.PersonID，这个条件有问题，好好看看吧

[杰拉尔]

select distinct a.*,b.Name,b.YM from T_InsideInfo as a
left join T_Personnel as b on a.PersonID=b.PersonID where
a.PID=b.PID and a.InID = '2d8b3586-f98b-4b55-bd0b-de1950bf1ee9' and a.IsDelete=0 order by a.CreateTime desc
看看。。

[hongcha99]

楼上的不幸，我写过如果按照你那样，则一条数据都查不出来

[Alex_Kael]

a.PersonID=b.PersonID

[宝_爸]

PersonID和PID都要相等才可以。

[sweet_]

就俩个表，定个sql有这么难么？你把表结构贴出来，要什么sql.我帮你写..另外你personid是干什么的？说明白一点呀，两表的关联条件？那你pid呢？...有关表sql让别人帮你看，就说清楚表的结构..又不是纯粹的sql语法

[hongcha99]

select distinct a.*,b.Name,b.YM from T_InsideInfo as a, T_Personnel as b where a.InID = '2d8b3586-f98b-4b55-bd0b-de1950bf1ee9' and a.PersonID=b.PersonID and a.IsDelete=0 order by a.CreateTime desc


这样写就好了