SQL Server – MS SQL: problem of joining two tables

I am still confused to join two tables.
I have two tables: Raw_Data and Totals. I have to join them, but I'm wrong about the result.

Here is my table of raw data:

FUsername | PARENT | Child
WIL111 | ABC | ABC_VIVO

WIL111 | ABC | ALT_KATONG

WIL111 | ALT | ALT_KATONG

Here is my total table:

User name | Parent | Child | Total
WIL111 | ABC | ABC_VIVO | 15

WIL111 | ABC | ALT_KATONG | 15

WIL111 | ALT | ALT_KATONG | 8

select FUsername, FChild_WP, AA_WC_TOTALS.TOTTotalSum_Parent,

dbo.RAW_DATA

JOIN dbo.TOTALS on RAW_DATA.FUsername = Totals.Username AND

RAW_DATA.FChild_WP = Totals.Child AND

RAW_DATA.Parent = Totals.Child

ORDER BY User Name, Child;

He shows me this exit:

Parent | User name | Child | Sum

ABC | WIL111 | ABC_VIVO | 15

ALT | WIL111 | ALT_KATONG | 15

ALT | WIL111 | ALT_KATONG | 8

If you see, it should be the double ABC and not the double ALT. Please help. I'm trying to change the conditions, but I can not get the correct data.

I'm expecting an exit like:

Parent | User name | Child | Sum
ABC | WIL111 | ABC_VIVO | 15

ABC | WIL111 | ALT_KATONG | 15

ALT | WIL111 | ALT_KATONG | 8

Thank you!