Thank you very much Jason , I have tried it and its worked.

Thank you very much John

hai dt,

    here is the query for your first case,

   select s2.name,s2.city

   from sales s1,sales s2

   where s1.name='Jones'

   and s1.city=s2.city

    try it..

 regards,

 Biju.