In SQL I have added a table to my query from a different database that shows its linked on the query.
I have also done a left outer join in the query aswell.
However when loading the view to excel the column appears but all the rows are blank.

I have attached the table in the query, the written query line where the table is joined and what my excel sheet shows. Any helpful fixes here would be great thanks

All values to load onto excel