一个复合SQL语句问题,请帮忙

发布网友发布时间：2022-04-07 20:00

共5个回答

热心网友时间：2022-04-07 21:29

你提取的字段不对,最好用内连接.
select c.class_name, r.res_prompt from class c inner join res r on c.class_id=r.res_classid where r.res_type=1 and r.race_id="&id&"

热心网友时间：2022-04-07 22:47

sql = "select class_id,class_name from class where class_id in (select res_classid as class_id from res where res_type=1 and race_id="&id&") "
试试看用in的时候里面有一个列就好了最好同名

热心网友时间：2022-04-08 00:22

sql = "select class_id,class_name from class where class_id in (select res_classid from res where res_type=1 and race_id="&id&") "。。。。。。

热心网友时间：2022-04-08 02:13

sql="select c.class_id,c.class_name ,r.res_prompt from class as c,res as r where c.class_id in (select res_classid from res where res_type=1 and race_id="&id&") and c.class_id=r.res_classid";

这句基本OK。

热心网友时间：2022-04-08 04:21

select a.class_name as class_name ,b.res_prompt as res_prompt from class as a,(select res_classid,res_prompt from res where res_type=1 and race_id="&id&") as b where a.class_id=b.res_classid