1 Reply Latest reply: Apr 4, 2012 12:10 PM by 926913 RSS

    Writing Self Join

    926913
      Hi All,

      please help me in writing the self join.

      I have to restrict the data by giving the self join on the same table. i have country code column and date column.

      Requirement : I should not see the data only for country code =99 from date>Jan 2012
      but i have to see the entire data for all the country codes(but applying the condition like "country code =99 from date<Jan 2012")

      can some one please help me. please let me know if i am not clear.

      Thanks,
      Anil