SQL - Zeilen in Spalten

[muadeep]

dachte da irgendwie so in der Art!

select a.WERKNR,a.TEXT,b.TEXT,c.TEXT
  from MyFile a, MyFile b, MyFile c           
    where (a.WERKNR = b.WERKNR and b.WERKNR = c.WERKNR) and a.WERKNR = '7500691'