iOS-SQLite数据库表链接

作为笔记，后面补充

/*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 = '鲁菜'); 嵌套查询，不叫表链接*/