求SQL嵌套查询的练习题,一定带数据表
发布网友
发布时间:2022-05-17 12:47
我来回答
共3个回答
热心网友
时间:2023-10-22 06:11
sele_tel="select companytel_bumen.bumenname,companytel_number.autoid as delid,companytel_number.name,companytel_number.wu,"
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"
热心网友
时间:2023-10-22 06:11
去我的共享文档去下
热心网友
时间:2023-10-22 06:12
我有套习题,不知道你满不满意。有意的话留下邮箱