两表有外键关系，但没有外键约束，根据A 表ID 查找B 表

Select s.ID as SID,s.NAME as SNAME,d.ID as DID,d.NAME as DNAME,d.SEQ as DSEQ,d.SYSDATE as DSYSDATE,d.ISACTIVES as DISACTIVES From TSPC as s,TSPCDETAIL as d where s.ID=d.SPECID
and SID=#{SID}，根据id 查找 TSPCDETAIL
可以这样写吗？where s.ID=d.SPECID and SID=#{SID}，主要是这句
谢谢啦！

可以，where不限定是否有约束关系，还可以用 inner join

SID=#{SID}

-- 这里的SID指定一下表名，然后你后面的是什么条件，也要指定

肯定可以啊，其实都不用改什么 了，SID你也已经定义为s.id了

还有 你这样查询 就已经是inner join 了

Select s.ID as SID,s.NAME as SNAME,d.ID as DID,d.NAME as DNAME,d.SEQ as DSEQ,d.SYSDATE as DSYSDATE,d.ISACTIVES as DISACTIVES From TSPC as s,TSPCDETAIL as d where s.ID=d.SPECID
and S.ID=#{SID}

多表关联查询默认已经是 inner join 关系了，