How do I convert this sql string into an ibatis sql string?

My sql string looks like this. And What I'd like to do is change it into a format ibatis can use

SELECT distinct( dbo.vwChangeMgmt1.number ) 
  FROM dbo.vwChangeMgmt1, dbo.vwChangeMgmtTask1
 WHERE dbo.vwChangeMgmt1.Asgn_Group != 'WTO-AMS-NOVUS' and     
       dbo.vwChangeMgmtTask1.Resource_group = 'WTO-AMS-NOVUS' and
       dbo.vwChangeMgmt1.number = dbo.vwChangeMgmtTask1

My Ibatis code

    SELECT * from
    vwChangeMgmt1 e, vwChangeMgmtTask1 f where
    (
    e.Asgn_Group != 'WTO-AMS-NOVUS' and
    f.Resource_group = 'WTO-AMS-NOVUS' and
    e.number = f.PARENT_CHANGE)

The problem with this is duplicates, and the DISTINCT portion returns errors.

Answers


I figured it out. I needed to change my result map line. the part in bold was added on the unique field.


Need Your Help

Add class to li with specific ID

javascript jquery html css

I want to add a class to a li with specific Id. I tried this:

UIBezierPath not drawing arc

ios core-graphics uibezierpath

I'm trying to draw a very simple circle. Here is my code: