# Viewing data from one column twice in SQL

**URL:** <https://forum.kirupa.com/t/viewing-data-from-one-column-twice-in-sql/96788>\
**Category:** Uncategorized\
**Created:** [December 13, 2003, 4:52pm UTC](https://forum.kirupa.com/t/viewing-data-from-one-column-twice-in-sql/96788 "2003-12-13T16:52:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![topper](https://avatars.discourse-cdn.com/v4/letter/t/9dc877/32.png) [@topper](https://forum.kirupa.com/u/topper)\
**Post date:** [December 13, 2003, 4:52pm UTC](https://forum.kirupa.com/t/viewing-data-from-one-column-twice-in-sql/96788/1 "2003-12-13T16:52:41Z")

</div>

Hi guys,

SOrry if the title is a bit misleading. I am a novice just getting into SQL.

Does anyone know how i would go about trying to gain information from one coloumn to output different values.

For example lets say i have a football team. I would like to know the names of all the people that have scored a goal from a penalty, but I would also like to know the name of the person who gave away the penalty. Does anyone know how i would start to go about doing this. Would i need a view, join (inner, outer, left, right) etc ?