Attachment SQL Query

[MrD3SAi]

Currently I have a query to get the attachments for a specific post:

PHP Code:

mysql_query("SELECT attachment.attachmentid AS attachmentid, covertype.type AS type FROM attachment LEFT JOIN covertype ON attachment.covertype = covertype.typeid WHERE attachment.postid = " . $threadinfo['firstpostid'] . " AND attachment.covertype != 0 ORDER BY attachment.covertype ASC") or die(mysql_error()); 


This works great; however, if I merge two posts and each post has attachment(s) it doesn't pull the attachment for the second post because

PHP Code:

WHERE attachment.postid = " . $threadinfo['firstpostid'] . 


Is there a way I can do a query based on all the post in the thread so it gets all the attachments for all the posts, not just the first one?