getting columns data rowwise

[percyvimal]

I have a table as given below 1 5 57 &Prosjekter 3 5 57 &Planning 3 5 122 &Proposal 3 5 232 &Preventive 3 5 233 &Paste Ctrl+V I want this in row wise select a,b,c,d,e,f where queryname and column a=&Prosjekter and column b=&Planning etc I need a query how i can get this done. Thank you with regards vimal Help in need is the help indeed

[Mazdak]

SELECT a,b,c,d,e,f FROM tablenamw WHERE a='&Prosjekter' AND b='Planning' Mazy You're face to face, With the man who sold the world - David Bowie