27,580
社区成员
发帖
与我相关
我的任务
分享
select * FROM bmdCustomer a join bdCustomerAllocate b ON (a.ID=b.CustomerID)
group by a.Id
order by a.lasteditdate desc
Select CustomerID From bdCustomerAllocate Group By CustomerID
你执行下就知道了嘛,只剩下CustomerID 这一列,还都是唯一的。
你假如要显示别的列,你前面也要加上去的,同时group by 的内容和select 的内容是除了sum, count 等都是一致的。
Select * From bmdCustomer a Inner Join
(Select CustomerID From bdCustomerAllocate Group By CustomerID ) b
On a.ID=b.CustomerID order by a.lasteditdate desc
只能得到A表的数据,B表的数据不显示了,我要两个表的数据都有显示的。