Thanks.

I've tried it two ways.  

1st.  use the sql

select
    o.Outage_ID,
    Summary,
    End_Date,
    Duration,
    Hit,
    Created_Date,
    Entered_By,
    Fixed_By,Fixed_Group,
    Root_Cause,
    Severity,
    Tracking_Number,
    Explanation,
    Corrective_Action,
    Additional_Contact,
    CIO_Comments,
    Duration_Available,
    Duration_Scheduled,
    Active,
    Validated,
    o.Modified_Date,
    o.Modified_By
from
    csu_outage o
    left outer join csu_outage_details d on o.outage_id = d.outage_id
But it automatically disables submit when I do this.

The second way is to use the interface by adding the tables and checking the
joins.  It creates a few extra joins which I removed and the submit is fine.  

CSU_Outages
   CSU_Outage_Details
(an outage can be associated with multiple systems)

The only problem with this is the issue below.  If select a query field in
CSU_Outages it filters the result set properly.  If I drop a query field(ex.
System_ID) from CSU_Outage_Details, it returns the entire data set.  I've
made the query field a text field and entered a specific value, I've also
made the query field a drop down list tying it to a secondary source.  

Still No luck.