mysql> SELECT
    ->     f.id,
    ->     f.name,
    ->     tmp.favoriteMeal
    -> FROM
    ->     (
    -> 
    ->         ( SELECT 1 AS id, "Pizza" AS favoriteMeal ) UNION ALL
    ->         ( SELECT 4 AS id, "Bella's Chicken Burrito" AS favoriteMeal ) UNION ALL
    ->         ( SELECT 5 AS id, "Vegan, Multi-Grain Pancakes" AS favoriteMeal )
    -> 
    ->     ) AS tmp
    -> INNER JOIN
    ->     friend f
    -> ON
    ->     f.id = tmp.id
    -> ORDER BY
    ->     f.id ASC
    -> ;
+----+-------+-----------------------------+
| id | name  | favoriteMeal                |
+----+-------+-----------------------------+
|  1 | Tina  | Pizza                       |
|  4 | Ralph | Bella's Chicken Burrito     |
|  5 | Sandi | Vegan, Multi-Grain Pancakes |
+----+-------+-----------------------------+
3 rows in set (0.00 sec)