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.
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.etula alleghaniensis is the provincial tree of Quebec, where it is commonly called merisier, a name which in France is used for the wild cherry. The name yellow birch reflects the color of the tree's bark.