Hi everyone,

I have this table:

TYPE ID Column3 Column4
-----------------------------
Data 001 Smith NY
Data 002 Lisa PA
Educ 001 Columbia BS
Educ 002 Harvard MBA

All right. Now if the user selects "S" he/she will get:
001 Smith Columbia BS

If the user selects "L" he/she will get:
002 Lisa Harvard MBA

I am a newbie at SQL, so this might be simple, but I am clueless about this. Can't exactly do JOIN because they're all in one table. But I don't know.

Thank you so much.

Martin