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.
Fall foliage color is yellow. River birch trees can be grown in planting zones 4-9 to provide the landscape with fall foliage. Native to the Eastern U.S., they will reach a height of 40-70 feet with a spread of 25-35 feet. These specimens are full-sun trees, but they will also tolerate partial shade.