Error: Column 'lastpost' in where clause is ambiguous

枫影谁用了

http://bbs2.chinaunix.net/forumdisplay.php?fid=2&filter=&orderby=replies

Discuz! info: MySQL Query Error

Time: 2010-10-30 11:51pm
Script: /forumdisplay.php

SQL: SELECT t.* FROM [Table]threads t
LEFT JOIN bbs_gbk.[Table]members m ON m.uid=t.authorid
WHERE t.fid='2' AND m.groupid not in (5) AND lastpost>='1285861897' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, replies DESC
LIMIT 30
Error: Column 'lastpost' in where clause is ambiguous
Errno.: 1052

Similar error report has beed dispatched to administrator before.
多表关联，，列相同又没有指定表了吧

send_linux

Discuz! info: MySQL Query Error

Time: 2010-10-30 11:51pm
Script: /forumdisplay.php

SQL: S ...
枫影谁用了 发表于 2010-10-30 23:55

    谢谢老版主的热心指出啊，呵呵

我已经反映给技术部的同事了