you will need to join the table to itself so that both columns can be returned on each row for the result set.