Thank you Johannes.
But I don't understand your code mean (Sorry that I am new to QlikView).
What I want is to embed user information in TABLE B into the report information table (TABLE A) with JOIN statement. Final outcome something like
TABLE A : Reportname, ReportDesc, ReportDate, OwnerID
TABLE B : UserID, UserName, UserTeam
OUTCOME TABLE C : Reportname, ReportDesc, ReportDate, UserName, UserTeam
Ah, I completely misunderstood the question. You're looking to do a join (either left join or right join, depending on what values you want to keep). In this case I assume that you only want to load values from Table B where the UserID exists as OwnerID in TableA, correct?
OwnerID as UserID
LEFT JOIN //This only keeps records where UserID in table B matches OwnerID in table A.