Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have UserID, TeamMember in table A. CEOID, TeamLeadID, CEOName, TeamLeadName in table B. I need to link UserID to both CEOID, TeamLeadID so that I have to show TeamMember as list box filter
UserID TeamMember
1 XX
2 YY
454 ZZ
977 SS
123 UU
6 IO
CEOID, TeamLeadID, CEOName, TeamLeadName
1 454 XX ZZ
2 123 YY UU
Please can anyone suggest me how to link this.
Thanks.
Please can anyone help me
any help please as it is very urgent
PFA
try this,if ur looking for different data set as out put just cahnge the join typr inner to leif/right and see..
Tab1:
Load * Inline [
UserID,TeamMember
1,XX
2,YY
454,ZZ
977,SS
123,UU
6,IO
];
Tab2:
Inner Join Load * Inline [
CEOID,TeamLeadID,CEOName,TeamLeadName
1,454,XX,ZZ
2,123,YY,UU
];