7 Replies Latest reply: Jul 13, 2012 8:27 AM by klangley RSS

    finding common customer in last 2 years

    sudeep dhoju

      Hi,

      i have table   year   cust

                          2012   aa

                          2012   bb

                          2012   cc

                          2011    aa

                          2011    dd

       

      here now since 'aa' repeats for both year 2011 and 2012, so i want to retrieve aa, what should be the expression??

       

      thanks