给我用的一段代码作为参考:
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";
解决方案 »
- mysql增删改太慢,求高手知道配置文件·
- mysql sql语句。
- mysql的一个库,既有myisam存储引擎表,又有innodb存储引擎表,如何做备份恢复方案!
- 如何insert 16进制数
- java从mysql数据库读出的中文是乱码怎么解决。
- postgresql怎么备份和恢复阿 。。。。
- 救命啊! 用客户端如ODBC访问远程MySQL中的blob字段亂碼,如何解決!!!
- select count(1) from table1 这句话count里有个1是什么意思?
- 求助:linux 下mysql编译问题
- 在redhat 5.1下如何安装mysql?
- 莫名其妙的Memory fault???
- mysql 紧急求助!!!!!!
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