select * from SysDataType as A left join
(select EMV_ID,EMV_SDT_ID,Isnull(EMV_PriceName,0)as EMV_PriceName ,Isnull(EMV_PriceStandard,0)as EMV_PriceStandard,EMV_FLAG,EMV_CreateTime,EMV_EditTime,EMV_COM_ID from ElecMeterValuation where EMV_COM_ID = 6)
as B on A.SDT_ID=B.EMV_SDT_ID
(select EMV_ID,EMV_SDT_ID,Isnull(EMV_PriceName,0)as EMV_PriceName ,Isnull(EMV_PriceStandard,0)as EMV_PriceStandard,EMV_FLAG,EMV_CreateTime,EMV_EditTime,EMV_COM_ID from ElecMeterValuation where EMV_COM_ID = 6)
as B on A.SDT_ID=B.EMV_SDT_ID
1 0 当日正向有功总 NULL NULL NULL NULL NULL NULL NULL NULL
2 1 当日正向有功尖 NULL NULL NULL NULL NULL NULL NULL NULL
3 2 当日正向有功峰 1 3 32 32 0 2010-09-15 17:39:56.000 2010-09-15 17:39:56.000 4
4 3 当日正向有功平 NULL NULL NULL NULL NULL NULL NULL NULL
5 4 当日正向有功谷 NULL NULL NULL NULL NULL NULL NULL NULL
6 5 当日正向无功总 NULL NULL NULL NULL NULL NULL NULL NULL
7 6 当日正向无功尖 NULL NULL NULL NULL NULL NULL NULL NULL
8 7 当日正向无功峰 NULL NULL NULL NULL NULL NULL NULL NULL
9 8 当日正向无功平 NULL NULL NULL NULL NULL NULL NULL NULL
10 9 当日正向无功谷 NULL NULL NULL NULL NULL NULL NULL NULL
select
a.*,
b.EMV_ID,
b.EMV_SDT_ID,
Isnull(b.EMV_PriceName,0)as EMV_PriceName ,
Isnull(b.EMV_PriceStandard,0)as EMV_PriceStandard,
b.EMV_FLAG,
b.EMV_CreateTime,
b.EMV_EditTime,EMV_COM_ID
from
SysDataType as A
left join ElecMeterValuation as B
on A.SDT_ID=B.EMV_SDT_ID
and b.EMV_COM_ID = 6