对存储过程的怀疑 [英] doubts on stored procedure

问题描述

在我的项目食品订购系统中，我有订单表，账单表和食品表。订单表的字段是：order_id，food_id，food_quantity。食品表的字段是：food_id，food_name，food_price。字段bill表的格式为：bill_id，order_id，food_id。



如何使用这些表数据编写存储过程来生成帐单？

解决方案

您好，



您可以使用LEFT JOIN来检索必要的项目明智数据。

 < span class =code-keyword> SELECT  b.bill_id，b.order_id，b.food_id，f.food_name，f.food_price，o.food_quantity  FROM  bill_table b LFFT  JOIN  food_table f  ON  f.food_id = b.food_id  LEFT   JOIN  order_table o  ON  o.order_id = b.order_id 

Regar DS，

in my project "food ordering system,i have order table,bill table and food table.The fields of order table are : order_id,food_id,food_quantity.The fields of food table are : food_id,food_name,food_price.The fields of bill table are : bill_id,order_id,food_id.

how can i write a stored procedure to generate a bill using these table data?

解决方案

Hello,

You can use LEFT JOIN to retrieve the necessary item wise data.

SELECT b.bill_id, b.order_id, b.food_id, f.food_name, f.food_price, o.food_quantity FROM bill_table b LFFT JOIN food_table f ON f.food_id = b.food_id LEFT JOIN order_table o ON o.order_id = b.order_id

Regards,

这篇关于对存储过程的怀疑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！