怎么能把这三条sql语句写成一句?
select c.* from t_cases c where TARGET_TYPE='A';
select c.* from t_target_case p join t_cases c on p.RESOURCE_ID=c.ID where p.USER_ID=(select user_Id from t_api_token where token='uQvdZVnMltke');
select c.* from t_cases c
inner join t_target_group_res g on g.RESOURCE_ID=c.ID and g.RESOURCE_TYPE='CASE'
inner join t_target_group_user u on u.GROUP_ID=g.GROUP_ID and u.USER_ID=(select user_Id from t_api_token where token='uQvdZVnMltke');
t_cases的TARGET_TYPE有A S G 三个值,当值为A的时候直接查出来,值为B 值为C分别对应2、3句的情况,现在能不能把这三句连起来,试过关联所有的表,查了70多秒才查出来