SELECT 
R.BranchSysNo, 
0,        
R.InvoiceSysNo,        
R.StoreSysNo,        
R.ItemSysNo,        
R.UnitSysNo,        
R.ReturnPrice,        
R.ReturnQuantity,        
CAST(R.ExpirationDate AS CHAR(8)),        
R.ReturnReasonType,        
R.ReturnReason,        
R.PurchasePrice,        
R.ItemCost,        
I.ItemNo,        
I.ItemName_A,        
I.ItemName_E,        
I.HasExpirationDate,        
S.StoreName,        
U.UnitName,        
U.UnitFactor 

FROM TB_Return R

INNER JOIN TB_Items I 
ON   I.YearSysNo    = 0 
AND  I.BranchSysNo  = R.BranchSysNo 
AND  I.StoreSysNo   = R.StoreSysNo 
AND  I.ItemSysNo    = R.ItemSysNo 

INNER JOIN TB_Stores S 
ON   S.BranchSysNo  = R.BranchSysNo 
AND  S.StoreSysNo   = R.StoreSysNo 

INNER JOIN TB_Units U 
ON   U.BranchSysNo  = R.BranchSysNo 
AND  U.UnitSysNo    = R.UnitSysNo 

WHERE R.BranchSysNo  = 1 
AND   R.InvoiceSysNo = 173 

GROUP BY I.ItemNo,R.UnitSysNo,R.ReturnQuantity,R.ReturnPrice

---

 Comments and Workarounds

---

The workaround is to move the:

I.YearSysNo = 0

expression from the JOIN clause into the WHERE clause.

---

 Resolution

---

Cannot Fix Problem

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial