[prottmann]

That is then not a problem of the SQL-Language, it is more a problem of the database design.

When you need really complex queries, you should think about a new db structure.

[jqm]

The largest database is vendor provided so we are stuck (for now).

Thanks for the insight.