Chain two joins
Join `visits` with `pets` on pet_id, then with `vets` on vet_id, both as left joins, so every visit row also shows the pet and vet details.
Join `visits` with `pets` on pet_id, then with `vets` on vet_id, both as left joins, so every visit row also shows the pet and vet details.