select IsNull(CO.ZWBH,'') as BoothNo , Case when( IsNull(CE.ComName,'')<>'') then CE.ComName when c.EName<>'' then C.EName else IsNull(o.ComName,'') end as ComName , Case when(IsNull(CE.Tel,'')='') then IsNull(CL.Tel,'') else CE.Tel end as Tel , Case when(IsNull(CE.Fax,'')='') then IsNull(CL.Fax,'') else CE.Fax end as Fax , Case when(IsNull(CE.Email,'')='') then IsNull(CL.Email,'') else CE.Email end as Email , Case when(IsNull(CE.Web,'')='') then C.Web else CE.Web end as WebSite, Case when(IsNull(CE.Business,'')='') then O.Business else CE.Business end as Business , Case when CE.Instruc is null then O.Instruc else CE.Instruc end as Instruc from Exh_2018.dbo.Clients AS CL inner join Exh_2018.dbo.CONTRACT AS CO on CL.UserID = CO.UserID inner join Exh_MS.dbo.Com C on C.userid = CL.UserID left join Exh_2018.dbo.Com_EN O on CL.UserID=O.USerID Left join Com_En AS CE on CL.UserID= CE.UserID where CL.UserID=618 Security China 2018 小牌九点数
2018 Exhibitors Lists
Fujian Aurine Technology Co., Ltd.
Main Products:
Booth No: W1B43
Tel 0591-38131976
Fax 38131800
Website: http://www.aurine.cn
Email: [email protected]
小牌九点数 甘肃快三手机上怎么买 免费四人麻将大全 广西快三直接开奖结果 快乐飞艇开奖记录 陕西快乐十分开奖结果走 河南快三投注平台 mg不朽的浪漫滴血条件 吉林麻将乐透 港彩论坛118资料红姐 有牛牛的游戏