110,534
社区成员
发帖
与我相关
我的任务
分享
select a.ID,a.OrderID,b.[Name] as pName,a.Quantity,a.Sum,a.[Date],a.IsPay,c.Name as mName
from
([Order] a left outer join Product b on a.ProductID=b.ProductID)
left outer join Member c on a.MemberID=c.MemberID
where 1=1 order by a.ID Desc
select top 25
a.[ID],a.[OrderID],b.[Name] as pName,a.[Quantity],a.[Sum],a.[Date],a.IsPay,
c.[Name] as mName
from [Order] a,Product b,Member c
where a.ProductID=b.ProductID and a.MemberID=c.MemberID
order by a.[ID] Desc