Generating full SQL in query subject

[sidney786]

Hi

I am trying to generate SQL from a query subject, within report studio 10.2

However the sql generated is missing joins possibily being executed at the application layer

I have my FM data source set to limited local.

Is there a way i can view to complete SQL generated by my query?

Thanks

Sid

[bdbits]

If you want to be absolutely certain of what is being generated, it can normally be captured by a DBA on the database side when you run the report.