%entities; %constants; ]>

SELECT chimpids.chimpid AS chimpid , biography_data.animid AS animid , biography_data.animid_num AS animid_num , biography_data.animname AS animname , biography_data.birthgroup AS birthgroup , biography_data.bgcertainty AS bgcertainty , biography_data.sex AS sex , biography_data.momid AS momid , biography_data.dadid AS dadid , biography_data.dad_prelim AS dad_prelim , biography_data.dad_published AS dad_published , biography_data.firstborn AS firstborn , biography_data.birthdate AS birthdate , biography_data.bdmin AS bdmin , biography_data.bdmax AS bdmax , biography_data.bddist AS bddist , biography_data.entrydate AS entrydate , biography_data.entrytype AS entrytype , biography_data.departdate AS departdate , biography_data.departdateerror AS departdateerror , biography_data.departtype AS departtype , biography_data.import_datetime AS import_datetime , twins.twin AS twin FROM biography_data JOIN chimpids ON (chimpids.animid = biography_data.animid) LEFT OUTER JOIN twins ON (twins.animid = biography_data.animid);

If we could we would display here the diagram showing how the CHIMPS view is constructed.