SQL - Outer Joins


The BASIS DBMS is capable of using left, right, and full outer joins, for example:

SELECT * FROM {OJ item LEFT OUTER JOIN category ON item.prod_cat = category.prod_cat }



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.