Abator and Table join

[Tony Qian]

All,

I'm using Abator generated code for iBATIS DAO.

Since Abator generated query doesn't support table join. I put following mapping in the Abator generated xml file
 
<select id="Coupon" resultMap="CouponForDisplay" >
     select
        prod.product_name,
        b.brand_name,
        C.coupon_id
      FROM coupon as C,  product_type as prod,  brand as b
      WHERE  C.product_type_id=prod.product_type_id and C.brand_id=b.brand_id;
  /select>

I got following error.

NestedRuntimeException: Could not find SQL statement to include with refid 'parkview_coupon.abatorgenerated_Example_Where_Clause'

Anything I did wrong?

Thanks,
Tony