Hello.
You can use a table as link of itself:
SELECT a.field1, b.field1, c.field1
FROM table1 a, table1 b, table1 c
WHERE a.id = b.id
AND a.id = c.id
ORDER BY 1,2,3
Table1 is always the same and field also, but used as different tables. Now you can use the WHERE clause to extract...