sql - .NET¼¼Êõ / C#

"select (select LogisticsCompanyName from tb_LogisticsCompany where LogisticsCompanyID=a.LogisticsCompanyID) as 'LogisticsCompanyName',a.LogisticsCompanyOrderfrom,a.OrderfromID,b.MemberName,case a.OrderfromState when 0 then 'µÈ´ý·¢»õ' when 1 then 'ÒÑ·¢»õ' end as OrderfromState,a.AppendTime from tb_Orderfrom a inner join DeliverGoods_Address b on a.DeliverGoods_AddressID=b.ID where b.MemberID=(select MemberID from tb_Member where MemberName='{0}')"

---

dddddddddd

---

ddddddd

---

select *
(select LogisticsCompanyName from tb_LogisticsCompany where LogisticsCompanyID=a.LogisticsCompanyID) 
as 'LogisticsCompanyName',
a.LogisticsCompanyOrderfrom,
a.OrderfromID,b.MemberName,
case a.OrderfromState 
when 0 then 'µÈ´ý·¢»õ' 
when 1 then 'ÒÑ·¢»õ' end
 as OrderfromState,a.AppendTime
 from tb_Orderfrom a 
 inner join DeliverGoods_Address b 
 on a.DeliverGoods_AddressID=b.ID 
 where b.MemberID=(select distinct MemberID from tb_Member where MemberName='{0}'
 )

---

ʲôÎÊÌ⣿

---

Òª±£Ö¤select distinct MemberID from tb_Member where MemberName='{0}'
Õâ¾ä²é³öÀ´µÄ½á¹ûΨһ²ÅÐÐ
£¬·ñÔò¾ÍÕâÑù
select *
(select LogisticsCompanyName from tb_LogisticsCompany where LogisticsCompanyID=a.LogisticsCompanyID)  
as 'LogisticsCompanyName',
a.LogisticsCompanyOrderfrom,
a.OrderfromID,b.MemberName,