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.
This tree has a rounded canopy and grows to a maximum height of 70 feet and width of 60 feet. River birch trees grow rather quickly, at a rate of about 1.5 feet per year. By the age of 20 years, they usually are between 30 and 40 feet tall. Sweet birch trees (Betula lenta) are hardy in USDA zones 3 through 8. These water-loving trees feature sweet-smelling leaves and bark, which gives rise to the tree's common name. They grow at a moderate rate and present at about 6 feet tall at 12 years. By age 20, they have an average height of about 46 feet.