永发信息网

SQL多表合并,难度问题,想挑战的来!

答案:3  悬赏:0  手机版
解决时间 2021-05-11 15:52
  • 提问者网友:情歌越听越心酸
  • 2021-05-11 06:52

表1的SQL

select
wsm_datahead.gettime as gettime,wsm_data_3.dataid as datid,wsm_data_3.data1 as datasw
from
wsm_data_3,wsm_DataBlock,wsm_datahead
WHERe
wsm_data_3.DataBlockID=wsm_DataBlock.DataBlockID
and
wsm_DataBlock.dataheadid=wsm_datahead.dataheadid
and
MHID=1112

表2的SQL

合并的条件是

表1的on wsm_datahead.gettime as gettime 的时间大概时间等于表2的wsm_datahead.gettime as gettime2时间误差不多于1个小时左右就合并显示为一条数据

显示的格式为

wsm_data_3 asdataid,wsm_data_3.data1 as datasw,data_7.data1 as databg,wsm_datahead.gettime

如果大家没看清楚了提示下其实这里涉及4个表.

最佳答案
  • 五星知识达人网友:老鼠爱大米
  • 2021-05-11 07:55
问题补充  2010-08-12 11:46

表2的SQL没贴上补贴


select
wsm_datahead.gettime as gettime2,wsm_data_7.dataid as datid2,wsm_data_7.data1 as databt
from
wsm_data_7,wsm_DataBlock,wsm_datahead
WHERe
wsm_data_7.DataBlockID=wsm_DataBlock.DataBlockID
and
wsm_DataBlock.dataheadid=wsm_datahead.dataheadid
and
MHID=1112

全部回答
  • 1楼网友:青灯有味
  • 2021-05-11 08:52
表1、表2...如果查询出来字段一样可以使用union all,最好贴三个表的数据截图,然后写条件及要的结果
  • 2楼网友:醉吻情书
  • 2021-05-11 08:12
union all
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯