mysql query error

[ck nuke]

Hi

I have a problem about : mysql query
I need help for this.
Sever: mysql Version: 4.0.4-bata
SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t, cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT 0,1
When use this command, no result
-------------------------------------------------------------------
SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t, cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.pid DESC LIMIT 0,1
When use this command, have one result
-------------------------------------------------------------------
SELECT pid FROM cdb_posts ORDER BY dateline DESC
When use this command, have results
-------------------------------------------------------------------
Don't know where is the mistake???

_________________________________________________________________
享用世界上最大的电子邮件系统— MSN Hotmail。 http://www.hotmail.com

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php