Re: How to recuperate data from other records in the same table

[Barry Galbraith]

Join the dogs table to itself twice, with alias for sire and alias for dam.

SELECT dog_id
dogs.dog_name
dogs.dob
sire.dog_name as sire
dam.dog_name as dam
FROM dogs
JOIN dogs as sire
ON dogs.sire_id = sire.dog_id
JOIN dogs as dam
ON dogs.dam_id = dam.dog_id;

Good luck,
Barry.