The BASIS ODBC Driver 2.0 is capable of using outer joins, for example:
SELECT * FROM {OJ item LEFT OUTER JOIN category ON item.prod_cat = category.prod_cat }