select distinct platform_code from acorn_radial_nonqc.acorn_radial_nonqc_timeseries_url UNION select distinct platform_code from acorn_radial_qc.acorn_radial_qc_timeseries_url
Results in:
BONC
BONC, Bonney Coast
CBG
CBG, Capricorn Bunker Group
COF
COF, Coffs Harbour
COF, Coffs Harbour (NSW), North Nambucca (NSW)
COF, Coffs Harbour (NSW), Red Rock (NSW)
CORL
CORL, Coral Coast
NEWC
NEWC, Newcastle
NWA, Northwest Australia
“NWS”
NWS
ROT
ROT, Rottnest Shelf
SAG
SAG, South Australia Gulf
SAG, South Australian Gulf
TURQ
TURQ, Turqoise Coast
Results in:
Note the double-quoted "NWS".