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.
Betula alleghaniensis (Yellow Birch), is a species of birch native to eastern North America, from Newfoundland to Prince Edward Island, Nova Scotia, New Brunswick, southern Quebec and Ontario, and the southeast corner of Manitoba in Canada, west to Minnesota, and south in the Appalachian Mountains to northern Georgia.