strSQL$ = strSQL$ & "INSERT INTO [Funds w/Performance Differences] " strSQL$ = strSQL$ & " ( org_name, product_name, org_id, product_id, fundid ) " strSQL$ = strSQL$ & "SELECT DISTINCTROW " strSQL$ = strSQL$ & " First([Sybase: qst_master_orgs].organization_name) AS org_name, " strSQL$ = strSQL$ & " First([Sybase: qst_master_products].product_name) AS product_name, " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].org_id, " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].product_id, " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].fundid " strSQL$ = strSQL$ & "FROM ( " strSQL$ = strSQL$ & " ([Sybase: qst_master_orgs] " strSQL$ = strSQL$ & " INNER JOIN [Sybase: qst_master_products] ON " strSQL$ = strSQL$ & " [Sybase: qst_master_orgs].org_id = [Sybase: qst_master_products].org_id) " strSQL$ = strSQL$ & " INNER JOIN [Sybase: qst_master_funds] ON " strSQL$ = strSQL$ & " ([Sybase: qst_master_products].product_id = [Sybase: qst_master_funds].product_id) AND " strSQL$ = strSQL$ & " ([Sybase: qst_master_products].org_id = [Sybase: qst_master_funds].org_id)) " strSQL$ = strSQL$ & " INNER JOIN [Sybase: qst_imq_to_pd_changes] ON " strSQL$ = strSQL$ & " ([Sybase: qst_master_funds].org_id = [Sybase: qst_imq_to_pd_changes].org_id) AND " strSQL$ = strSQL$ & " ([Sybase: qst_master_funds].product_id = [Sybase: qst_imq_to_pd_changes].product_id) AND " strSQL$ = strSQL$ & " ([Sybase: qst_master_funds].fundid = [Sybase: qst_imq_to_pd_changes].fundid) " strSQL$ = strSQL$ & "WHERE (([Sybase: qst_imq_to_pd_changes].update_type='Return Change') AND " strSQL$ = strSQL$ & " ((Abs([old_value]-[new_value])*100)>50) AND " strSQL$ = strSQL$ & " ([Sybase: qst_imq_to_pd_changes].commit_date Is Null)) OR " strSQL$ = strSQL$ & " (([Sybase: qst_imq_to_pd_changes].update_type='Return Change') AND " strSQL$ = strSQL$ & " ((Abs([old_value]-[new_value])*100)>50) AND " strSQL$ = strSQL$ & " ([Sybase: qst_imq_to_pd_changes].review_date>[Sybase: qst_imq_to_pd_changes].[commit_date])) " strSQL$ = strSQL$ & "GROUP BY " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].org_id, " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].product_id, " strSQL$ = strSQL$ & " [Sybase: qst_imq_to_pd_changes].fundid " strSQL$ = strSQL$ & "ORDER BY " strSQL$ = strSQL$ & " First([Sybase: qst_master_orgs].organization_name), " strSQL$ = strSQL$ & " First([Sybase: qst_master_products].product_name); " MyDB.Execute strSQL$