您好,登錄后才能下訂單哦!
select distinct b.MaterialID,a.id,a.InNo,a.Title,a.FromType,a.FromBillID,d.orderNo ,a.Executor,h.EmployeeName as ExecutorName,a.Processor,e.EmployeeName as ProcessorName ,a.EnterDate,a.projectID,a.totalProduct ,case a.billStatus when '0' then '制單' when '1' then '執(zhí)行' when '2' then'結(jié)單' end as b illStatus ,a.DepId,f.CustName,b.ID as detailID,b.ProductNo,b.ProductName,b.Specification,b.size ,b.unit,b.StorageID,c.StorageName,b.StorageDID,sd.ProductCount,c.StorageDName ,b.ProductCount,b.procedureNO,b.arts,b.RunCard,b.RuncardStatus from officedba.OutSourceInfo a left join officedba.OutSourceDetail b on a.InNo=b.InNo left join officedba.StorageDetailInfo c on c.ID=b.StorageDID and c.StorageNo=b.StorageID left join officedba.PurchaseOrder d on a.FromBillID=d.OrderNO left join officedba.EmployeeInfo e on e.ID=a.Processor left join officedba.ProviderInfo f on f.ID=a.DepId left join officedba.EmployeeInfo h on h.ID=a.Executor left join officedba.ProductInfo i on b.ProductNo=i.ProdNo left join MaterialDetailInfo j on j.MD03=i.ID left join officedba.CodeUnitType cu on cu.ID=b.Unit left join officedba.TechnicsArchives ta on ta.TechNo=b.arts left join officedba.RunCardDetail sd on sd.runcard=b.runcard and sd.ProcedureID=b.procedureNO where a.InNo='CKDBH2017040060'
之前寫(xiě)過(guò)一個(gè)關(guān)聯(lián)查詢和子查詢效率對(duì)比的博客,流露出自己對(duì)關(guān)聯(lián)查詢的青睞,如果邏輯足夠清晰,關(guān)聯(lián)查詢是一個(gè)不錯(cuò)的選擇。(上面是自己剛寫(xiě)的一個(gè)關(guān)聯(lián)查詢的sql語(yǔ)句,拿出來(lái)曬曬,總覺(jué)得有一兩米長(zhǎng))
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。