在mysql中加入两组给定的查询

作者: 哦哦了
发布时间: 2025-02-06 02:39:54 (21天前)
转自：

3 条回复

0#
回复此人
Just do it | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <pre> <code> SELECT c.cy_id, c.to_id AS tsn, se.x AS tX, se.y AS ty, c.fr_id AS fsn, sef.x AS fX, sef.y AS fy FROM c JOIN se ON c.to_id = se.ar JOIN se as sef ON c.fr_id = sef.ar UNION -- UNION ALL may be better SELECT c.cy_id, c.to_id, swt.x, swt.y, null, null, null FROM c JOIN swt ON c.to_id = swt.ar </code> </pre> </DIV>

编辑
1#
回复此人
老人与海。 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> <EM> 的<strong> 你应该试试这个： <a href="http://sqlfiddle.com/#!2/1b660/3" rel="nofollow"> http://sqlfiddle.com/#!2/1b660/3 </A> </强> </EM> <强/> </p> <pre> <code> SELECT A.cy_id, A.to_id AS tsn, B.x AS tX, B.y AS ty, C.x AS tx, C.y AS tY, A.fr_id AS fsn, BB.x AS fX, BB.y AS fy FROM c A JOIN se AS B ON A.to_id = B.ar JOIN swt C ON A.to_id = C.ar JOIN se BB ON A.fr_id = BB.ar; </code> </pre> </DIV>

编辑

登录后才能参与评论