Revert to complex subqueries.  I think you might be allowed to make
modifications when you're only dealing with inner joins.  I'll know
for sure in an hour or two.  This may not work, either.  If it doesn't,
I'm at a loss as to how one is supposed to make this kind of code go
with Sybase ASE.