34,576
社区成员
发帖
与我相关
我的任务
分享
select t1.c, t2.e,t2.f,t2.g,t2.h
from table1 t1
inner join table2 t2 on t1.id=t2.aid
where t1.b=[某值]
SELECT
a.c, b.e, b.f, b.g, b.h
FROM
a
INNER JOIN b
ON a.id=b.aid
WHERE
a.b='xxx'
select
a.c,b.*
from
a inner join b
on
a.id=b.aid
where
a.b='xxx'
是不是这个意思?