Aliased tables are not correctly referenced in convenience views.

[simon-brooke]

We're seeing this:

------------------------------------------------------------------------
--	convenience view lv_animal of entity animal for lists, et cetera 
------------------------------------------------------------------------
CREATE VIEW lv_animal AS
SELECT holding.holding_identifier ||', '|| holding.name AS holding_expanded,
	animal.holding,
	animal.animal_identifier ||', '|| animal.name AS dam_expanded,
	animal.dam,
	animal.animal_identifier ||', '|| animal.name AS sire_expanded,
	animal.sire,
	animal.born,
	animal.animal_identifier,
	animal.name,
	gender.gender AS gender_expanded,
	animal.gender,
	species.species AS species_expanded,
	animal.species,
	breed.breed AS breed_expanded,
	animal.breed,
	animal.is_pedigree,
	pasture.name ||', '|| pasture.area AS pasture_expanded,
	animal.pasture,
	animal.id
FROM species, pasture, breed, gender, animal, holding
WHERE animal.holding = holding.id
	AND animal.dam = animal.id
	AND animal.sire = animal.id
	AND animal.gender = gender.gender
	AND animal.species = species.species
	AND animal.breed = breed.breed
	AND animal.pasture = pasture.id
;

Clearly, animal.animal_identifier ||', '|| animal.name AS dam_expanded should be dam.animal_identifier ||', '|| dam.name AS dam_expanded