,
shipping_zip_code,
shipping_city,
shipping_state,...'D' then a_shipping_city
else b_shipping_city
end shipping_city...a.shipping_city a_shipping_city,
a.shipping_state a_shipping_state,...b.shipping_city b_shipping_city,
b.shipping_state b_shipping_state,...,
shipping_zip_code,
shipping_city,
shipping_state