clomama :D

如何抽取指定數值?

Discussion created by clomama :D on May 10, 2016
Latest reply on Jun 2, 2016 by Wing Fat Leung

Hi,

 

請問 Table B 如何做? 已將兩個table用"Client ID"連接關係。

 

Table A 已有以下數據:

Client IDClient NameNumber TypeContact Number
1CherylHome Tel12345678
1CherylOffice Tel56789681
1CherylMobile64857896
2KarlHome Tel86954681
2KarlOffice Tel78956315
2KarlMobile98468513

 

Table B 需要以下數據:

Client IDClient NameNumber TypeContact Number
1CherylOffice Tel56789681
2KarlMobile98468513

 

謝謝!

Outcomes