Group1 Order1 Group2 Order2 PAM 1 HNWI 1 PAM 1 Hedge Funds 2 PAM 1 PFs 3 PAM 1 ETFs 4 PIM 1 Pvt Insts 1 PIM 1 Banks 2 PIM 1 Trusts 3
Id Name Record_Type Close_Date Status Role__c Group1 Group2 a0L7000000Cyk0fEAB 84001166 Open Opportunities 00:00.0 Forecast Sales - Gov - West & MidWest PAM ETFs a0L7000000Cyk0gEAB 84001167 Open Opportunities 00:00.0 Forecast Sales - Gov - West & MidWest PAM PFs a0L7000000Cyk0hEAB 84001168 Open Opportunities 00:00.0 Forecast Sales - Gov - West & MidWest PAM HNWI a0L7000000A1kEeEAJ 82949995 Open Opportunities 00:00.0 Forecast Business - Index and Analytics PIM Banks a0L7000000AusDkEAJ 83431781 Open Opportunities 00:00.0 Forecast Sales - Gov - Boston PAM HNWI
select order1, order2 from transaction_Master tm Join ordering_master om ON tm.group_1= om.group1 and tm.group_2=om.group2 order by order1, order2
DISTINCT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)