Reported By: Fernando Dias Reported On: 11/14/2004 For: Version 4.14 Build 1
# 1902SQL Joins on any Expressions or Columns Whose Data Types Do Not Match Causes Incorrect Results The following query causes incorrect results.
selectDataPedido, TipoCom, CodCom, NumPedido, Ref, Qt
from PedidosD D left outer join Pedidos P on
D.TipoCom=P.TipoCom and D.CodCom=P.CodCom and D.NumPedido=P.NumPedido
CommentsThe D.NumPedido column was a float column while the P.NumPedido column was an integer.
ResolutionFixed Problem on 11/15/2004 in version 4.15 build 1