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.