VNB3M73099
VNB3C06043
VNB3K07446


SELECT
               bldg.building_name,
               bd.room_name,
               concat(Make,' ', model) AS MakeModel,
               bd.serial_number,
               bd.vendor_mach_id,
               bd.projected_volume_black,
               bd.billed_projected_volume_black,
               bd.cpc_black,
               bd.projected_volume_color,
               bd.billed_projected_volume_color,
               bd.cpc_color,
               org.org_name,
               bd.vendor_cpc_black,
               bd.vendor_cpc_color
               
              FROM billing_data_archive bd
                INNER JOIN organization org ON bd.org_id_ma = org.id 
                INNER JOIN buildings bldg ON bd.building_id_ma = bldg.id 
                INNER JOIN machines mac ON bd.model_id = mac.id
                #INNER JOIN Machine_Archive ma ON ma.SerialNumber = bd.serial_number
                INNER JOIN organization vendOrg ON vendOrg.id = bd.vendor_id
                WHERE bd.billing_gp_id = 1495
                AND bd.Traded NOT IN('Yes', 'Y') /******************added this*********/               
                ORDER BY bldg.building_name, bd.room_name;
                
                
                SELECT DISTINCT Traded FROM billing_data_archive; /*****************too many options************/