给我用的一段代码作为参考:
var strSQL = "select Topics.*, Post.name as postname, Post.nickname as postnickname, LastReply.name as lastreplyname, LastReply.nickname as lastreplynickname from Topics " +
"left join UserBasic as Post on (Topics.postuserid = Post.id) " +
"left join UserBasic as LastReply on (Topics.lastreplyuserid = LastReply.id) " +
"where Topics.boardid=? order by Topics.lastreplytime desc";
var strSQL = "select Topics.*, Post.name as postname, Post.nickname as postnickname, LastReply.name as lastreplyname, LastReply.nickname as lastreplynickname from Topics " +
"left join UserBasic as Post on (Topics.postuserid = Post.id) " +
"left join UserBasic as LastReply on (Topics.lastreplyuserid = LastReply.id) " +
"where Topics.boardid=? order by Topics.lastreplytime desc";
select j.stinms, c.cyounm, j.cyomen, j.gaikun, j.jyuukn, s.goutou, s.heyabg
from cyoumei as c INNER JOIN jyuukyo as j INNER JOIN syugsti as s
on j.hkcode = s.hkcode
on j.tuuhac = 变量 and
j.kbnkon = 变量 and
j.haituj = 变量 AND
j.kencod = c.kencod and
j.sicode = c.sicode and
j.cyoucd = c.cyoucd