hi thxs for your reply.i think i did not say clearly what i want.the query u gave resulted in diff answer.
table name: PROFIT
fields:ID,FIRST NAME,LAST NAME,EMP,CONDITION
1.... AN............... YT ........S .......A
2.... NH................ZK..........D...... A
3.... GR...