SQL SELECT Statement

Posted by mouthpiec on Stack Overflow See other posts from Stack Overflow or by mouthpiec
Published on 2010-05-04T19:25:53Z Indexed on 2010/05/13 17:24 UTC
Read the original article Hit count: 340

Filed under:
|

I have a table with the following columns:

 id, teamA_id, teamB_id

Will it be possible to write a SELECT statement that gives both teamA_id and teamB_id in the same column?

EDIT:

Consider this example

From

 id, teamA_id, teamB_id
 1, 21, 45
 2, 34, 67

I need

Teams
21
45
34
67

© Stack Overflow or respective owner

Related posts about sql

Related posts about select