Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
create view UPS_TRACKING as SELECT NUMBER,PO_NO AS UPS_TRACK FROM SALES_HISTORY_HEADR UNION ALL SELECT NUMBER,REF_NO AS UPS_TRACK FROM PURCHASE_ORDER_HEADR
update UPS_TRACKING SET UPS_TRACK = 'UPS Tracking Number' where number = '0000100598'
create view UPS_TRACKING as SELECT NUMBER,PO_NO AS UPS_TRACK FROM SALES_HISTORY_HEADR
Join the community of 500,000 technology professionals and ask your questions.