P
papa jonah
I have a table that has a field (org) that has data like
AA-2
AA-2
AA-2
AA-1
AA-D
NMT-D
NMT-4
NMT-4
I want a query that will list all of the organizations (1 time) that
are represented to the left of the dash.
For example, the results of the query on the above table would be
AA
NMT
TIA
AA-2
AA-2
AA-2
AA-1
AA-D
NMT-D
NMT-4
NMT-4
I want a query that will list all of the organizations (1 time) that
are represented to the left of the dash.
For example, the results of the query on the above table would be
AA
NMT
TIA