selecting data from a table with a query

Hello

I have a table like this:

ID p1 p2 p3
-- --- --- ---
1 22 33 44
2 55
3 66 77

Im trying to write a query that will output :

ID Phone
-- -------
1 22
1 33
1 44
2 55
3 66
3 77


Thank you

 

Google 'sql join', joins might be able to do it.

 

Learn how to normalize your database.

 

Use UNION ALL

SELECT id, p1 AS Phone FROM table
UNION ALL
SELECT id, p2 FROM table
UNION ALL
SELECT id, p3 FROM table
ORDER BY id

Code (markup):

 

nice tips and trick, thx.
but...
for the same case maybe you have to add for "select distinct"

 

Good point wardz. You can achieve this if you do not use ALL with UNION

SELECT id, p1 AS Phone FROM table
UNION 
SELECT id, p2 FROM table
UNION 
SELECT id, p3 FROM table
ORDER BY id

Code (markup):