Select the join line in the Diagram pane, and then from the Query Designer menu, choose, selecting the command that includes the table whose extra rows you want to include. Choose the first table to create a left outer join.
The heritage river birch (scientific name Betula nigra Heritage) is the most popular and widely grown type of river birch tree. The distinctive bark is the main feature of the tree and sets it apart from other river birches.
There are many species of Birch trees which means the second word in the name is different for different types (species) of birch trees. Some example scientific names of birch trees include: Betula ienta (the cherry birch), Betula pubescens (the European white birch), Betula glandulosa (the American dwarf birch).