jun li Mon, 26 Sep 2011 03:31:50 -0700
hi, it seems that mapjoin and distinct can not be together. else it throw Parse Error
select distinct /*+ MAPJOIN(a) */ or select /*+ MAPJOIN(a) */ distinct -- Li Jun