Select posts from forum

[Stasik]

Hey.... i`m a bit confised now :(

i need to select all posts knowking just forumid IN 1 QUERE...

postid->threadid->forumid

any ideas?

[Admin]

SELECT * FROM post
LEFT JOIN thread USING (threadid)
WHERE thread.forumid=1;

[Stasik]

cool, respect....... tnx

[Stasik]

i have it more complicated

i have a table called xxx where is a column with postid.... i need a query which select data from table xxx using forumid :(

[Stasik]

SELECT * FROM xxx LEFT JOIN post USING (postid) LEFT JOIN thread USING (post.threadid) WHERE thread.forumid=2


i think smth like that.... but cant get it ready :(

[Admin]

SELECT * FROM xxx
LEFT JOIN post USING (postid)
LEFT JOIN thread USING (threadid)
WHERE thread.forumid=2
I just hope you don't have a threadid column in your xxx table.