... I keep getting NULLS in the new PlantName column from the SELECT statement and it doesn't seem like it's bringing over the data associated with the "ALL"...
The rows are not "unnecessary", they are just the result of a "cartesian product" (or "cross join") - described here - because not every table in your view is in...
When people say "SQL Server", they are not talking about the language "SQL". They instead are referring to the name of a Microsoft database product ... I'm just guessing...