作为笔记,后面补充
/*SELECT f.name, ft.name FROM t_food f, t_food_type ft WHERE f.food_type_id = ft.id AND ft.name = '鲁菜'; 表链接*/
或者
/*SELECT f.name, ft.name FROM t_food f JOIN t_food_type ft WHERE f.food_type_id = ft.id AND ft.name = '鲁菜'; 表链接*/
/*SELECT * FROM t_food WHERE food_type_id = (SELECT id FROM t_food_type WHERE name = '鲁菜'); 嵌套查询,不叫表链接*/