There is an artifical way to do the outer join in PostgreSQL... It involves using UNION and NOT IN... see : http://www.postgresql.org/docs/aw_pgsql_book/node305.html Hope this helps... -jag -- "She who is wanting me, Whose touch can make me cry, I can only understand By never asking her why..." -John Popper
