select A.HEM_ID,A.HEM_TableNO,A.HEM_TableName,A.HEM_COMM_ADDR,B.HHD_ID,B.HHD_HouseNo,B.HHD_HouseName,C.CCT_ID,C.CCT_NO,C.CCT_NAME,C.CCT_INSTADDR,
D.cta_id,D.cta_areacode,D.cta_areaname,HHA_ID,HHA_Addr
from ((HolderElecMeters as A left join Concentrators as C on A.HEM_CCT_ID = C.CCT_ID)
left join CopyTableArea as D on A.HEM_CTA_ID = D.cta_id)
left join (select B.*,E.* from HouseHolders as B left join HouseHolderAddress as E on B.HHD_ID = E.HHA_HHD_ID) as F
where A.HEM_Flag =0 and A.HEM_COM_ID=4
D.cta_id,D.cta_areacode,D.cta_areaname,HHA_ID,HHA_Addr
from ((HolderElecMeters as A left join Concentrators as C on A.HEM_CCT_ID = C.CCT_ID)
left join CopyTableArea as D on A.HEM_CTA_ID = D.cta_id)
left join (select B.*,E.* from HouseHolders as B left join HouseHolderAddress as E on B.HHD_ID = E.HHA_HHD_ID) as F
where A.HEM_Flag =0 and A.HEM_COM_ID=4
select A.HEM_ID,A.HEM_TableNO,A.HEM_TableName,A.HEM_COMM_ADDR,B.HHD_ID,B.HHD_HouseNo,B.HHD_HouseName,C.CCT_ID,C.CCT_NO,C.CCT_NAME,C.CCT_INSTADDR,
D.cta_id,D.cta_areacode,D.cta_areaname,HHA_ID,HHA_Addr
from HolderElecMeters as A --去掉括号
left join Concentrators as C on A.HEM_CCT_ID = C.CCT_ID)
left join CopyTableArea as D on A.HEM_CTA_ID = D.cta_id)
left join
(select B.*,E.* from HouseHolders as B left join HouseHolderAddress as E on B.HHD_ID = E.HHA_HHD_ID) as F on 条件 --加上条件
where A.HEM_Flag =0 and A.HEM_COM_ID=4
D.cta_id,D.cta_areacode,D.cta_areaname,HHA_ID,HHA_Addr
from HolderElecMeters as A --去掉括号
left join Concentrators as C on A.HEM_CCT_ID = C.CCT_ID --去掉括号
left join CopyTableArea as D on A.HEM_CTA_ID = D.cta_id --去掉括号
left join
(select B.*,E.* from HouseHolders as B left join HouseHolderAddress as E on B.HHD_ID = E.HHA_HHD_ID) as F on 条件 --加上条件
where A.HEM_Flag =0 and A.HEM_COM_ID=4
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
select A.HEM_ID,A.HEM_TableNO,A.HEM_TableName,A.HEM_COMM_ADDR,
F.HHD_ID,F.HHD_HouseNo,F.HHD_HouseName, --改成F
C.CCT_ID,C.CCT_NO,C.CCT_NAME,C.CCT_INSTADDR,
D.cta_id,D.cta_areacode,D.cta_areaname,
HHA_ID,HHA_Addr --前面的前缀呢?
from HolderElecMeters as A --去掉括号
left join Concentrators as C on A.HEM_CCT_ID = C.CCT_ID --去掉括号
left join CopyTableArea as D on A.HEM_CTA_ID = D.cta_id --去掉括号
left join (select B.*,E.* from HouseHolders as B
left join HouseHolderAddress as E on B.HHD_ID = E.HHA_HHD_ID)
as F on 条件 --加上条件
where A.HEM_Flag =0 and A.HEM_COM_ID=4
HouseHolderAddress as e
其中HolderElecMeters是主表
表字段有id,b_id,b_name,c,id,c_name,d_id,d_name
HouseHolders 字段有b_id,b_name
Concentrators 字段有c_id,c_name
CopyTableArea 字段有d_id,d_name
HouseHolderAddress 字段有e_id,e_name,b_id,b_name
要把HolderElecMeters作为主表查询,
select a.*,b.*,c.*,d.*,e.*
from a
left join b on a.b_id=b.b_id
left join c on a.c_id=c.c_id
left join d on a.d_id=d.d_id
left join e on b.b_id=e.b_id
where 条件