从table1中的列获取值,这些值是table2中两列的值的组合。 Table1.col3派生为Table2.col4 +& quot ;;& quot; + Table2.col5。 [英] Getting values from a column in table1 which are combination of values from two columns in table2 . Table1.col3 is derived as Table2.col4 + ";" + Table2.col5.
问题描述
表1中包含col1,col2,col3。表2具有col4,col5
col3 fom table1是表2中col4,col5的组合。即col3 = col4; col5
例如:
表1                                                          
col1 col2   col3
1  约翰   abc; tech
2   sweety xyz; sql
3  乔     名称是sdf;茶
表2
col4 col5
abc 技术
xyz sql
sdf tea
如何从col3派生col4和col5并在表1中生成
col3 = col4然后 col4如何只包含sdf。它应该是 名称是sdf右跨度>
Table 1 has col1, col2, col3. Table 2 has col4, col5
col3 fom table1 is combination of col4, col5 from table 2 . That is col3=col4;col5
For example:
Table1
col1 col2 col3
1 john abc;tech
2 sweety xyz;sql
3 joe Name is sdf;tea
Table2
col4 col5
abc tech
xyz sql
sdf tea
How to derive col4 and col5 from col3 and generate in table 1
col3=col4 then how col4 only contains sdf . It should be Name is sdf right?
这篇关于从table1中的列获取值,这些值是table2中两列的值的组合。 Table1.col3派生为Table2.col4 +& quot ;;& quot; + Table2.col5。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!