INNER JOIN same table twice? 1

[snowboardr]

I am basicly trying to select posts and grab the category names the post is in (ptid & ptid2) but I can't seem to get my INNER join to work... any suggestions?

SELECT post.ptid,post.ptid2,post.puid,post.psubject,post.ptype,post.ptime,thread1.tid,thread1.tname,thread2.tid,thread2.tname FROM forumpost as post, thread1 as thread INNER JOIN ON thread1.tid=post.ptid AND thread2.tid=post.ptid WHERE post.puid=2

 

[snowboardr]

*correction i had these swtiched... but still not working errors

thread as thread1
thread as thread2

 

[r937]

SELECT post.ptid
     , post.ptid2
     , post.puid
     , post.psubject
     , post.ptype
     , post.ptime
     , thread1.tid
     , thread1.tname
     , thread2.tid
     , thread2.tname 
  FROM forumpost as post
INNER
  JOIN thread as thread1
    ON thread1.tid = post.ptid 
INNER 
  JOIN thread as thread2 
    ON thread2.tid = post.ptid2 
 WHERE post.puid = 2

r937.com | rudy.ca

 

[snowboardr]

Thanks r937 thanks a lot !!