SELECT a.adjective,
b.animal
FROM sec1309_table1 AS a, sec1309_table2 AS b
WHERE a.adjective = b.animal
order by b.animal;

adjective    |  animal

apple           Ape
blue            buck
red             rooster

apple ape
blue  buck
red   rooster

SELECT a.adjective, b.animal
FROM sec1309_table1 AS a
INNER JOIN sec1309_table2 AS b ON LEFT(a.adjective, 1) = LEFT(b.animal, 1)
order by b.animal;