这两条怎样合成一条....
$query = $sdb->query("SELECT t.*, p.rate, p.pid FROM {$tablepre}threads t
LEFT JOIN {$tablepre}posts p USING(tid, dateline)
$query = $sdb->query("SELECT t.*,count(a.tid) as aaa FROM {$tablepre}threads t
LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0
大家明不明白我的意思???
$query = $sdb->query("SELECT t.*, p.rate, p.pid FROM {$tablepre}threads t
LEFT JOIN {$tablepre}posts p USING(tid, dateline)
$query = $sdb->query("SELECT t.*,count(a.tid) as aaa FROM {$tablepre}threads t
LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0
大家明不明白我的意思???
LEFT JOIN {$tablepre}posts p USING(tid, dateline)
$query = $sdb->query("SELECT t.*,count(a.tid) as aaa FROM {$tablepre}threads t
LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0 两句变成一句..........这可以吗?$query = $sdb->query("SELECT t.*, p.rate, p.pid, count(a.tid) as aaa FROM {$tablepre}threads t
LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0 && {$tablepre}posts p USING(tid, dateline)
你的问题是想问:怎么讲sql由两条变成一条 用一个query搞定它是吗?
LEFT JOIN {$tablepre}posts p USING(tid, dateline)