Displaying 1 result from an estimated 1 matches for "animaltransfertyp".
Did you mean:
animaltransfertype
2012 Mar 07
1
SELECT CASE in RODBC
...e:
raw<-sqlQuery(.zz,
'SELECT TOP(100)PERCENT
Animal.Herdnumber AS herd, Animal.ChrNumber AS chrNr,
Animal.AnimalNumber AS animalid, Animal.DateOfBirth AS datebirth,
AnimalStatus.Code AS codestatus, AnimalStatus.Description AS
animalstatus,
AnimalTransfer.Date AS date,
AnimalTransferType.Code AS codeevent, AnimalTransferType.Description AS
event
FROM
Animal
FULL JOIN
AnimalTransfer ON Animal.AnimalNumber = AnimalTransfer.AnimalNumber
FULL JOIN
AnimalTransferType ON AnimalTransfer.AnimalTransferTypeId =
AnimaltransferType.RowId
FULL JOIN
AnimalStatus ON Anim...