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.
River birch is a fast-growing, deciduous semi-aquatic tree that reaches between 50 and 90 feet in height. Its diamond shaped, double-toothed leaves produce an erect or spreading canopy that covers an extensive area. The leaves turn yellow in the fall.