Question

怎么写sql 查询语句,一个表中包括2个外键,想查出外键表中的信息

orderdetailtbl表中有id(主键), orderID(外键;ordertbl表中主键), menuID(外键,meuntbl 表中主键),num.

ordertbl表中有id(主键), ordertime, userid, tableid .
menntbl表中有id(主键), name. price
要查出orderdetailtbl表中一条 包括ordertbl表中ordertime , tableid 和meuntbl表中name 的值,
要怎么写sql 语句?

Answer 1

select a.id, a.orderID, a.menuID,a.num,b.ordertime, b.userid, b.tableid, c.name, c.price from orderdetailtbl a
join ordertbl b on a.orderID=b.id
join menntbl c on a.menuID=c.id