|
wsilage
Starting Member
USA
22 Posts |
 Posted - 02/20/2013 : 13:39:37
|
I need to find a way to capture if all locations that are termed under a pcs and not just 1 or two locations are. I am not sure how to do that. However, there is a field called pcsa_id2. This field has how many location there are. I am sure I can us that field some how, just unsure how to write code for that.
Example if you look at the pcsa_id1 this tells you that there are 3 locations and they are all termed
I am not sure how to capture this.
pro_pcs (distinct) Pcsa_id1, Pcsa_id1 term location
00000254 00000254 0001 02/20/13
00000254 00000254 0002 02/20/13
00000254 00000254 0003 02/20/13
|
|
Query find all locations
