mysqlのマルチテーブル連合クエリーmybatis resultmap
329 ワード
#左外部ジョインクエリー
select * from t_setmeal sm left join t_setmeal_checkgroup sc on sm.id = sc.setmeal_id left join t_checkgroup cp on sc.checkgroup_id = cp.id left join t_checkgroup_checkitem cc on cp.id = cc.checkgroup_id left join t_checkitem ci on cc.checkitem_id = ci.id where sm.id=13
select * from t_setmeal sm left join t_setmeal_checkgroup sc on sm.id = sc.setmeal_id left join t_checkgroup cp on sc.checkgroup_id = cp.id left join t_checkgroup_checkitem cc on cp.id = cc.checkgroup_id left join t_checkitem ci on cc.checkitem_id = ci.id where sm.id=13