LEFT + FULL JOIN Query by UserName, Sql Server

Language: Layout:

IF OBJECT_ID('dbo.UserTable', 'U') IS NOT NULL 
  DROP TABLE dbo.UserTable;

IF OBJECT_ID('dbo.BaseInfoTable', 'U') IS NOT NULL 
  DROP TABLE dbo.BaseInfoTable;

IF OBJECT_ID('dbo.AddInfoTable', 'U') IS NOT NULL 
  DROP TABLE dbo.AddInfoTable; 
  
  
  
CREATE TABLE UserTable (
    username INT,
    firstname VARCHAR(10),
    lastname VARCHAR(10)
);

CREATE TABLE BaseInfoTable (
    username INT,
    year INT,
    one INT
);
  
CREATE TABLE AddInfoTable (
    username INT,
    year INT,
    four INT
);
  
  
INSERT INTO UserTable VALUES (1234, 'Joe', 'Smith');
INSERT INTO UserTable VALUES (1245, 'Mike', 'Horton');
INSERT INTO UserTable VALUES (1326, 'Jess', 'Thomas');
 
INSERT INTO BaseInfoTable VALUES (1234, 2019, 1);
INSERT INTO BaseInfoTable VALUES (1326, 2019, 1);
INSERT INTO BaseInfoTable VALUES (1234, 2018, 1);

INSERT INTO AddInfoTable VALUES (1234, 2019, 4);
INSERT INTO AddInfoTable VALUES (1245, 2019, 4);
INSERT INTO AddInfoTable VALUES (1234, 2018, 4);
INSERT INTO AddInfoTable VALUES (1245, 2018, 4);

SELECT DISTINCT
     RL.UserName
    ,RL.Firstname
    ,RL.Lastname
    ,COALESCE(BIO.Year, PHA.Year) As Year
    ,BIO.One    
    ,PHA.Four

FROM    UserTable RL 
        LEFT OUTER JOIN AddInfoTable PHA
            ON RL.UserName = PHA.Username
        FULL OUTER JOIN  BaseInfoTable BIO
            ON RL.UserName = BIO.Username
ORDER BY 
    COALESCE(BIO.Year, PHA.Year) DESC;

View schema
Execution time: 0,03 sec, rows selected: 5, rows affected: 10, absolute service time: 0,2 sec, absolute service time: 0,2 sec