It doesn't support UNION ALL, Views, Stored procedures, temp tables. However, it does support all type of joins, sub queries.

I understand, this is annoying, but that where the issue is. Without these limitations, we could have used UNION ALL. But now we are compelled to find alternate approach/SQL.

thanks for responding.