SQL ÕâÑùµÄÌõ¼þÅжÏÔõôд

SQL code:

CREATE TABLE test(
[id1] [int] NULL,
[id2] [int] NULL,
[name] [varchar](100) NULL,
[meters] [varchar](200) NULL
) ON [PRIMARY]
insert into test select '1001','2001','A','200'
insert into test select '1002','2002','B' ,''
insert into test select '1003','2003','C','300'
insert into test select '1004','2004','D',''



CREATE TABLE test1(
[id] [bigint] NULL,
[meter] [int] NULL,
[Limit] [int] NULL
)
insert into test1 select '01','100','200'
insert into test1 select '02','80','300'


CREATE TABLE test2(
[id] [bigint] NULL,
[lid] [int] NULL,
[currents] [float] NULL
)
insert into test2 select '1000','2001','500'
insert into test2 select '1000','2003','750'


CREATE TABLE temp(
[id] [bigint] NULL,
[lid] [int] NULL,
[currents] [float] NULL
)
insert into temp select '01','1001','335'
insert into temp select '02','2002','450'


select t.id1,t.id2,t.name,tp1.currents as current1, tp2.currents as current2,
(tp1.currents+tp2.currents) as totalcurrent, t2.Currents,t1.Limit
Case when (¡­¡­) then '¿ÉÒÔ'
when isnull(tp2.currents, '')='' then '²»È·¶¨'
else '²»¿ÉÒÔ' end as Title

from test as t
left join temp as tp1 on tp1.lid=t.id1
left join temp as tp2 on tp2.lid=t.id2
left join test2 as t2 on t.id2=t2.lid
left join test1 as t1 on t.meters=t1.meter
where