which of the following is true when using an inner join? select the best answer from the following. a. only rows from the left-side of the join are returned if there is no match for that row in the table on the right-side of the join. b. all rows from the left-side of the join are returned and then matched against related rows from the table on the right-side of the join. c. all rows from the right-side of the join are returned and then matched against related rows from the table on the left-side of the join. d. only rows that have related rows on both sides of the join are returned.