Postgres Joins ?

Hi,

Would someone be able to assist with the following Postgres Query.

select t.id,q.name,t.subject,u.name,t.status,t.created,t.resolved,ov.content,ov.created as Updated from tickets t,
queuesq, users u, objectcustomfieldvalues ov where t.created > '2007-10-02 00:00:00' AND t.queue = 6 and t.queue = q.id
ANDt.owner = u.id and ov.objectid = t.id and ov.customfield = 21 order by t.id; 

which returns the following:

id   |   name    |  subject   |   name    |  status  |    created           |          resolved       | content
|   updated 

-------+-----------+-----------------------------------------------------------------------------------+--------------+----------+--------
12345    Fred       Purchase     bob         Resolved    2007-10-21 14:01:23    2007-10-31 09:03:40    Captured
2007-10-2114:03:32     
12345    Fred       Purchase     bob         Resolved    2007-10-21 14:01:23    2007-10-31 09:03:40    Released to WH
2007-10-2207:34:01 
12345    Fred       Purchase     bob         Resolved    2007-10-21 14:01:23    2007-10-31 09:03:40     Delivered
2007-10-3108:58:53 


What I'd like to have is the following:

id   |   name    |  subject   |   name    |  status  | created             |captured            | released to wh     |
delivered         |  resolved 
12345    Fred       Purchase    bob        Resolved   2007-10-21 14:01:23  2007-10-21 14:03:32     2007-10-22 07:34:01
2007-10-31 08:58:53   2007-10-31 09:03:40 


Is this possible ? I suspect it requires the use of Joins in some manner, but my SQL knowledge is not up to scratch.
I'dappreciate 
it if someone could point me in the right direction.




Regards,

Tony Wade
postgres@wade.co.za