Bumping is defined as posting two or more times in succession without adding anything new to the issue you are trying to address. But I add anything new the the issue to resolve the problem.
If you want to add additional information, you can always go and edit your previous post in case you’re the last poster. The bumping rule has this information.
On the universe parameters tab, change the ANSI92 flag from NO to YES.
You’ll have to modify your joins - ANSI92 will let you have better outer joins but it deson’t support using a (+) to denote an outer join. Either let Bob build the ANSI syntax for you, or code it manually:
from tableA left outer join tableB on tableA.columnx=tableB.columnx
Are you just trying to report off these three tables?
The simplest solution is to make everything equi-joins and then handle categories and items that don’t have an item category as separate data providers. The other solution is to create a derived table that is a cartesian product of the category and item tables and then do an outer join from the derived table to the item category table.
(BOB member since 2005-03-01)
(BOB member since 2008-05-12)
(BOB member since 2003-09-17)