Time enabled layers don't like joins in SQL?

[Anonymous User]

I have a series of layers with joins whose data source was changed from Oracle to SQL (SDE). They stopped working after the change. Turns out that if I drop the join, the time-enabling works. This is the error I get when I try to access one of the layers with time enabled and the join in place:

When I drop the join, it works fine.

Dropping the join isn't the end of the world, but I'd like to keep it. Time-enabling is more important. Is it possible to have both with SQL?

Thank you,

Randy