从多个表中获取数据 [英] fetch data from multiple table

问题描述

我有两张桌子一张酒店桌和另一张食物桌。我想从食物表中获取酒店ID基础知识的数据。意味着一家酒店有多种类型的食物，许多酒店都有相同的食物。那么如何从食品表中获取酒店ID的基本信息（酒店ID是父母）请告诉我查询。

解决方案

有一个名为JOIN的关键字可以让你加入两个或多个表并给出一个共同的结果。

您可能想要阅读一些关于DBMS基础知识的内容。

i have two table one hotel table and another food table. i want fetch data from food table on basics of hotel id. means one hotel have more than one type food and many hotel have same food. then how data is fetch from food table on basics of hotel id(hotel id is parent) please tell me query .

解决方案

There is a keyword called JOIN that allows you to join two or more tables and give out a common result.
You may want to do some reading on DBMS basics.

这篇关于从多个表中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！