Yes, but WHY? Why is it not using the Invnum tag on invitems first when using the left outer join. This seems like a fairly simple example and if I have to run sys(3054) on every SQL-Select statement I write... talk about a time-eater.
Brandon Harker
Sebae Data Solutions