下面有两个表:
1.sample
code | customer | samplelist | procnum |
011002 | a | 010-100 | 071033 |
011002 | a | 010-100 | 071034 |
011002 | a | 010-100 | 071035 |
011003 | b | 010-101 | 071033 |
011004 | c | 010-102 | 071034 |
011005 | d | 010-103 | 071035 |
011005 | d | 010-103 | 071034 |
011006 | e | 010-104 | 071036 |
2 order
code | customer | order | procnum |
011002 | a | df2007001 | 071033 |
011002 | a | df2007002 | 071033 |
011002 | a | df2007002 | 071034 |
011005 | d | df2007003 | 071034 |
那位高手知道我怎么能实现下面的表:
code | customer | samplelist | procnum | order |
011002 | a | 010-100 | 071033 | df2007001 |
011002 | a | 010-100 | 071033 | df2007002 |
011002 | a | 010-100 | 071034 | df2007002 |
011002 | a | 010-100 | 071035 | |
011003 | b | 010-101 | 071033 | |
011004 | c | 010-102 | 071034 | |
011005 | d | 010-103 | 071035 | |
011005 | d | 010-103 | 071034 | df2007003 |
011006 | e | 010-104 | 071036 |
就是在合并两个表的时候,关联的列有重复的情况怎么解决,能不能实现以多列关联合并两个表?
谢谢!!