UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'N/A' WHERE a._companyName = o._companyName AND o._mx >= 0 AND o._mx < 1<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'Below 5M' WHERE a._companyName = o._companyName AND o._mx >= 1 AND o._mx < 5000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '5 - 10M' WHERE a._companyName = o._companyName AND o._mx >= 5000000 AND o._mx < 10000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '10 - 25M' WHERE a._companyName = o._companyName AND o._mx >= 10000000 AND o._mx < 25000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '25 - 100M' WHERE a._companyName = o._companyName AND o._mx >= 25000000 AND o._mx < 100000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '100M - 1B' WHERE a._companyName = o._companyName AND o._mx >= 100000000 AND o._mx < 1000000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(_revenueRange) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'Above 1B' WHERE a._companyName = o._companyName AND o._mx >= 1000000000 AND o._mx < 9999999999999<BR>