SELECT * FROM PR_T_USER_PUNCH_CARD_DETAILS PUPCD
LEFT JOIN PR_T_USER_PUNCH_CARD PUPC ON PUPC.ID = PUPCD.UPC_ID
WHERE PUPCD.UPC_ID IN
<foreach item="split" index="index" collection="split"
open="(" separator="," close=")">
#{split}
</foreach>
foreach里为需要循环的对象,一般为数组
collection为我们传过来的数组名
item为每次循环取出来的值
open以什么开始
separator用什么分割
close以什么结尾