如何在sq self join l中交叉加入？ [英] How to do cross join in sq self join l?

问题描述

我在sql中有表格想要交叉加入或自我加入

名称值1 
 jim  100  
 jak  50  
 stiv  25  

预期结果

名称值1 
 Jim  100  
 Jim  50  
 Jim  25  
 jack  100  
 jack  50  
 jack  25  
 stiv  100  
 stiv  50  
 stiv  25  

我尝试了什么：



我还在努力，我想知道实现这一目标的最佳方法是什么

解决方案

  SELECT  t.name，t1.value 
  FROM  Table_1  AS  t  CROSS   JOIN  
 Table_1  AS  t1 
  ORDER   BY  t.infoID 

 从 myTable t1选择 t1.name，t2.value ，myTable t2 

只需编写查询

  SELECT  b.NAME，a.Value1 
  FROM  Table_1 a，Table_1 b 
 

我假设你的桌子名称是Table_1



快乐编码！ ：）

i have table in sql i want to cross join or self join

Name          Value1       
jim            100           
jak            50
stiv           25 

expected result

Name value1  
Jim   100 
Jim   50
Jim   25
jack  100
jack  50
jack  25
stiv  100
stiv  50
stiv  25 

What I have tried:

still i am working on it ,and i could like know what is the best method to achieve this

解决方案

SELECT        t.name, t1.value
FROM            Table_1 AS t CROSS JOIN
                         Table_1 AS t1
ORDER BY t.infoID

Select t1.name,t2.value from myTable t1, myTable t2

Just write the query

SELECT  b.NAME, a.Value1
    FROM Table_1 a, Table_1 b

I assumed that your table name is Table_1

happy coding! :)

这篇关于如何在sq self join l中交叉加入？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！