[SOLVED] not sure if this is a left join or not

[scarhand]

im working with vbulletin here

 

now the 'poll' table does not contain a forumid entry (which would make things easier), but the 'thread' table contains a pollid entry, as well as a forumid entry (polls are attached to threads)

 

both 'poll' and 'thread' tables contain a pollid entry

 

i am trying to get it to only display a poll from a specific forumid (5)

 

heres what i've got so far

 

$sql = 'SELECT * FROM poll, thread
              LEFT JOIN pollid ON poll.pollid = thread.pollid
              WHERE thread.forumid = 5 
              ORDER BY dateline DESC 
              LIMIT 1';

 

im no good at joining....any help would be greatly appreciated