求SQL嵌套查询的练习题，一定带数据表

来源：百度知道 编辑：UC知道 时间：2024/06/03 15:03:21
求SQL嵌套查询的练习题，一定带数据表 各位帮帮忙吧
禁止回答“网上多得不得了，可以去看看啊，那些表也不复杂，也就几个字段和几个表。”这种弱智傻瓜答案
回答类似答案的死一边去

sele_tel="select companytel_bumen.bumenname,companytel_number.autoid as delid,companytel_number.name,companytel_number.zhiwu,"
sele_tel=sele_tel&"companytel_number.zhuangxian,companytel_number.shirentel,companytel_number.neixian"
sele_tel=sele_tel&" from companytel_bumen inner join companytel_number on companytel_bumen.bumencode=companytel_number.bumencode"
sele_tel=sele_tel&" where companytel_bumen.company='"&companytelsort&"' and companytel_number.company='"&companytelsort&"' and companytel_number.showtag='YES'"
sele_tel=sele_tel&" order by companytel_bumen.taxisid,companytel_bumen.bumenname,companytel_number.taxisid,companytel_number.addteltime"

我有套习题，不知道你满不满意。有意的话留下邮箱

去我的共享文档去下