22,209
社区成员
发帖
与我相关
我的任务
分享
--------------
create table customer
(
id varchar(50) primary key ,
name varchar(50)
)
insert into customer(id,name)
select 'A01','张三' union
select 'A02','李四' union
select 'A03','王五' union
select 'A04','韩六' union
select 'A05','宋七'
create table ordergroup
(
id int primary key identity(1,1),
customerId varchar(50),
orderDate datetime,
currentDatePrice money,
currentDateCount int
)
insert into ordergroup(customerId,orderDate,currentDatePrice,currentDateCount)
select 'A01','20140812',100,4 union
select 'A02','20140812',50,2 union
select 'A03','20140811',43,1
select c.Id,c.Name,og.OrderDate,og.CurrentDatePrice,og.CurrentDateCount from
Customer as c left join OrderGroup as og on c.Id=og.CustomerId and OrderDate='20140812'