Outer/Inner Joins Question

[rcaesar]

Hi

I have a catalog with both inner and outer joins. I have a set of powerprompts to run the reports.

The report draws data from from two tables, but the drop downs for the powerprompts only come from one table.

Now, my question is:

In my SQL (in the ADO ) do I have to specify the inner and outer joins (as I have in my Catalog).

If the report is only from data in One table, and the prompts are also in that table, things work fine. But if there are multiple tables involved, the powerprompts run fine, but I get an error and the IWR won't run.

Any ideas? This is a great forum, I have always found some help.

Thanks