[返回电脑前线首页]·[所有跟帖]·[ 回复本帖 ] ·[热门原创] ·[繁體閱讀]·[版主管理] | |||
i have a trouble .. could u help me? i have two table select * from newschoolcombo; comboNo Tquantity ------------ ------------ combo3 400 combo2 340 combo4 200 combo1 620 select * from sandwichcombo; comboNo comboName comboprice ----------- --------------- ------------- combo1 A 4,22 combo2 B 1.232 combo3 C 9.334 if i want to display the comboName which has higher Tquantity .. it should show comboname -------- A how can i link the tables? i have had try : select comboName From SandwichCombo San , newschoolcombo news where san.comboNo = news.comboNo and news.Tquantity =(select max(Tquantity) From newschoolcombo) group by comboName; and it display so many error... | |||
|
|||
帖子内容是网友自行贴上分享,如果您认为其中内容违规或者侵犯了您的权益,请与我们联系,我们核实后会第一时间删除。 |
所有跟帖: ( 主贴楼主有权删除不文明回复,拉黑不受欢迎的用户 )
楼主本栏目热帖推荐:
>>>>查看更多楼主社区动态... |