TableName: Transaction Field TranNo Date Amount UserID 0001 01/01/2000 200 000001 0002 02/02/2000 100 000002 TableName: ContraLog Field TranNo Date UserID 0001 02/01/2000 000001 0002 02/02/2000 000002 TableName: User Field UserID UserName 000001 John 000002 Micheal How the sql statment look like if I need to generate the report look as the following?? Report Trans.TranNo Trans.Date Amount UserName1 Contra.Date UserName2 UserName1 = user name who match with Trans.UserID UserName2 = user name who match with Trans.UserIDThank you very much