Need Help with Lookup Multiple Rows from Other Tables in SQL

Any experts on using the lookup multiple rows from other tables? Im able to execute the lookup, but its not bringing every column from the other table