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.
The scientific name of the rainbow trout is Oncorhynchus mykiss. The species was originally named by German naturalist and taxonomist Johann Julius Walbaum in 1792 based on type specimens from the Kamchatka Peninsula in Siberia.