Displaying 1 result from an estimated 1 matches for "lactationnumb".
Did you mean:
lactationnumber
2012 Mar 07
1
SELECT CASE in RODBC
...T
Animal.Herdnumber AS herd, Animal.ChrNumber AS chrNr,
Animal.AnimalNumber AS animalid, Animal.DateOfBirth AS datebirth,
AnimalStatus.Code AS codestatus, AnimalStatus.Description AS
animalstatus,
calving.calvingdate AS date,
"codeevent" = CASE
WHEN calving.lactationnumber>0 THEN 1
ELSE NULL
END,
"event" = CASE
WHEN calving.lactationnumber>0 THEN "calving"
ELSE NULL
END
FROM
Animal
LEFT JOIN
calving ON Animal.animalnumber = calving.motheranimalnumber
LEFT JOIN
AnimalStat...