数据库jsp小总结

总结
select
a.id,
a.name,
a.startDate,
a.endDate,
u.name as owner (这个地方不能加逗号)

    from tbl_activity a
    join tbl_user u
    on a.owner=u.id
    where a.name like '%' #{aname} '%' and a.id not in(  
      select
      activityid
      from tbl_clue_activity_relation	 !这个地方一定是括号()不是{}
      where clueId=#{clueId}

    )

“clueId”:"${c.id}", 一定要有括号是字符串