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 river birch is a fast-growing, water-loving, deciduous tree, native to much of the United States. Its scientific name is Betula nigra. Unlike other birches that have white barks, the river birch's bark is reddish brown and curls and peels naturally, adding visual interest to the plant.
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.