I've found The PHP Anthology (PA) extremely useful for improving my knowledge after beginning with Kevin Yank's Introductory PHP/MySQL (KY) book.

However one thing that is missing from The PHP Anthology (PA) is the following:

KY regularly uses SELECT statements from multiple tables and a typical SQL SELECT statement might look like this:

SELECT * FROM animals, animal_homes WHERE animals.homeId=animal_homes.id;

Nowadays I'm using PDO Prepare and Execute as recommended in PA. However I don't know how to bind two columns to the same value as with the statement above where column animals.homeId is bound to column animal_homes.id.

Would be very grateful for some help on this one, since I really want to persevere with Prep Ex.

Thanks a million