求一mysql查询语句

[༺ཌༀཉི浮华背后༃ༀད༻]

table node :
nid name value
1   abc  123
2   def  456

table edge :
eid node1 node2 res
1   1     2     ok

查询结果:
eid name1 name2 res
1   abc   def   ok

[zhangzongchang]

select eid,node1.nid,node2.nid,res
from edge,node as node1,node as node2

[༺ཌༀཉི浮华背后༃ༀད༻]

结果有出入啊：

select eid,node1.nid,node2.nid
from edge,node as node1,node as node2

#result:
eid node1 node2
1   1     1    
1   2     1
1   1     2
1   2     2 

另，请问这是什么类型的查询？

[zhangzongchang]

连接查询吧

[shine333]

SELECT e.eid,
       n1.name AS name1,
       n2.name AS name2,
       e.res
  FROM edge e,
  LEFT JOIN node n1
    ON e.node1 = n1.nid
  LEFT JOIN node n2
    ON e.node2 = n2.nid

[sdojqy1122]

另外一种写法
select eid,n1.name,n2.name,res
from edge e,node n1,node n2 where e.node1 = n1.nid and e.node2 = n2.nid

[ACMAIN_CHM]

select e.eid,n1.name as name1,n2.name as name2,res
from edge e,node n1,node n2
where e.node1=n1.nid and e.node2=n2.nid 

[woaikeer123]

SQL codeselect e.eid,n1.name as name1,n2.name as name2,res
from edge e,node n1,node n2
where e.node1=n1.nid and e.node2=n2.nid

[༺ཌༀཉི浮华背后༃ༀད༻]

ok，感谢上面各楼的帮助，请问：
如何将#2的查询结果存入新的表中？

[WWWWA]

假设新表结构与SELECT语句结果一致
insert into 新表
select eid,node1.nid,node2.nid
from edge,node as node1,node as node2

[༺ཌༀཉི浮华背后༃ༀད༻]

如果要显示合并的name怎么实现？

查询结果: 
eid name1 name2 res name
1   abc   def   ok  abc_def

[WWWWA]

CONCAT(name1,'-', name2)

[༺ཌༀཉི浮华背后༃ༀད༻]

over，暂时的问题全解决了，感谢各位O(∩_∩)O谢谢