Question

asp的小问题，同时查询A,B表的sql语句怎么写的？

a表表字段：id,product,bigid
b表字段: id,classname
其中a.bigid=b.id，已知a.id,求b.classname

这样写好像不对：
select bigclass from Hu_bigclass where id =(select bigid from Hu_product where id="&id&")

Answer 1

"select m.classname from b as m,a as n where n.bigid=m.id and n.id="&id

或者

"select classname from b where id in(select bigid from a where id="&id&")"

Answer 2

select y.classname from a x,b y where x.bigid=y.id and x.id=?