asked on
Get Max date using a join.
I need to get the max date and minimum price contained within 2 tables. As the data is so large I attached only a small amount but here are many drug names in this database. Below are the results of this query . What I really need is etc. I am using sql 2003
What I need is
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.75 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TABLET 1 1.3716 64720013210 20070601
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 0.9621 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00406888601 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.1647 54868538700 20050811
gnc_seqno ln gni awp ndc NPT_DATEC
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.75 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TAB 1 112.5 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.362 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.4525 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 36.2 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 45.25 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9818 54868472805 20060210
005000 AMPHETAMINE SALTS 10 MG TAB 1 117.81 54868472805 20060210
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.0827 54868472804 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1494 54868472803 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2827 54868472801 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 2.016 54868472800 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 20.16 54868472800 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 38.48 54868472801 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 103.45 54868472803 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 108.27 54868472804 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1828 54868472802 20050623
005000 AMPHETAMINE SALTS 10 MG TAB 1 70.97 54868472802 20050623
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.3716 53489056601 20041119
005000 AMPHETAMINE SALTS 10 MG TAB 2 137.16 53489056601 20041119
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 63304090901 20041018
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 63304090901 20041018
005000 AMPHETAMINE SALTS 10 MG TAB 2 0.9238 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.1548 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.4285 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 92.38 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 115.48 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 142.85 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.204 54868472804 20031229
005000 AMPHETAMINE SALTS 10 MG TAB 1 320.4 54868472804 20031229
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3502 57866393502 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3633 57866393501 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 40.9 57866393501 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 121.52 57866393502 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 2.9218 54868472802 20030321
005000 AMPHETAMINE SALTS 10 MG TAB 1 175.31 54868472802 20030321
005000 AMPHETAMINE SALTS 10 MG TAB 1 4.29 54868472800 20030120
005000 AMPHETAMINE SALTS 10 MG TAB 1 42.9 54868472800 20030120
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.0217 54868472801 20030117
005000 AMPHETAMINE SALTS 10 MG TAB 1 90.65 54868472801 20030117
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9921 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2401 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.4287 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 99.21 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 124.01 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 142.87 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00185011101 20020614
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00185011101 20020614
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.8632 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2817 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 86.32 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 128.17 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TABLET 1 1.3716 64720013210 20070601
005000 AMPHETAMINE SALTS 10 MG TABLET 1 137.16 64720013210 20070601
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 0.9621 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 1.2026 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 1.4285 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 96.21 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 120.26 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 142.85 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.2026 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.4285 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 96.21 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 120.26 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 142.85 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.5993 57866707201 20031001
047132 AMPHETAMINE SALTS 12.5 MG TB 1 47.98 57866707201 20031001
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.2026 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.4285 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 96.21 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 120.26 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 142.85 00555077602 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.1647 54868538700 20050811
047133 AMPHETAMINE SALTS 15 MG TAB 1 104.82 54868538700 20050811
047133 AMPHETAMINE SALTS 15 MG TAB 2 0.9621 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 1.2026 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 1.4285 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 96.21 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 120.26 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 142.85 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 1 0.9621 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.2026 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.4285 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 96.21 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 120.26 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 142.85 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 0.9621 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.2026 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.4285 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 96.21 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 120.26 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 142.85 00555077702 20030319
005001 AMPHETAMINE SALTS 20 MG TAB 1 3.75 23490797506 20071011
005001 AMPHETAMINE SALTS 20 MG TAB 1 225 23490797506 20071011
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.362 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.4525 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 36.2 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 45.25 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.716 54868510303 20050525
005001 AMPHETAMINE SALTS 20 MG TAB 1 34.32 54868510303 20050525
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.3716 53489056901 20041119
005001 AMPHETAMINE SALTS 20 MG TAB 2 137.16 53489056901 20041119
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1494 54868510302 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1828 54868510301 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.616 54868510300 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 48.48 54868510300 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 70.97 54868510301 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 103.45 54868510302 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 63304091001 20041018
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 63304091001 20041018
005001 AMPHETAMINE SALTS 20 MG TAB 2 0.9238 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.1548 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.4285 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 92.38 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 115.48 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 142.85 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.2278 54868510301 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.9827 54868510300 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 89.48 54868510300 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 133.67 54868510301 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.1946 54868510302 20040707
005001 AMPHETAMINE SALTS 20 MG TAB 1 197.51 54868510302 20040707
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3469 57866393602 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.36 57866393601 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 40.8 57866393601 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 121.22 57866393602 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9921 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.2401 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.4287 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 99.21 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 124.01 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 142.87 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00185040101 20020614
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00185040101 20020614
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.8632 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.2817 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 86.32 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 128.17 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TABLET 1 1.3716 64720013510 20070601
005001 AMPHETAMINE SALTS 20 MG TABLET 1 137.16 64720013510 20070601
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.362 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.4525 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 36.2 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 45.25 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.317 54868486300 20060623
034359 AMPHETAMINE SALTS 30 MG TAB 1 39.51 54868486300 20060623
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.3716 53489057001 20041119
034359 AMPHETAMINE SALTS 30 MG TAB 2 137.16 53489057001 20041119
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 63304091101 20041018
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 63304091101 20041018
034359 AMPHETAMINE SALTS 30 MG TAB 2 0.9238 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.1548 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.4285 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 92.38 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 115.48 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 142.85 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3469 57866394902 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.36 57866394901 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 40.8 57866394901 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 121.22 57866394902 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 3.344 54868486300 20030725
034359 AMPHETAMINE SALTS 30 MG TAB 1 100.32 54868486300 20030725
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9921 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.2401 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.4287 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 99.21 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 124.01 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 142.87 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00185040401 20020614
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00185040401 20020614
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.8632 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.2817 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 86.32 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 128.17 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TABLET 1 1.3716 64720013610 20070601
034359 AMPHETAMINE SALTS 30 MG TABLET 1 137.16 64720013610 20070601
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.25 23490797303 20071011
004999 AMPHETAMINE SALTS 5 MG TAB 1 127.5 23490797303 20071011
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.362 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.4525 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 36.2 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 45.25 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.516 54868463103 20050623
004999 AMPHETAMINE SALTS 5 MG TAB 1 90.96 54868463103 20050623
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.3716 53489056401 20041119
004999 AMPHETAMINE SALTS 5 MG TAB 2 137.16 53489056401 20041119
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 63304090801 20041018
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 63304090801 20041018
004999 AMPHETAMINE SALTS 5 MG TAB 2 0.9238 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.1548 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.4285 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 92.38 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 115.48 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 142.85 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3469 57866393402 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.36 57866393401 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 40.8 57866393401 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 121.22 57866393402 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.2118 54868463103 20030320
004999 AMPHETAMINE SALTS 5 MG TAB 1 252.71 54868463103 20030320
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.3443 54868463102 20030116
004999 AMPHETAMINE SALTS 5 MG TAB 1 100.33 54868463102 20030116
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00185008401 20020927
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00185008401 20020927
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9921 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2401 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.4287 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 99.21 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 124.01 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 142.87 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.204 54868463100 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.4115 54868463101 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 88.23 54868463101 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 320.4 54868463100 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.3702 54868463100 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.629 54868463101 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.58 54868463101 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 337.02 54868463100 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2819 00185008401 20020502
004999 AMPHETAMINE SALTS 5 MG TAB 1 128.19 00185008401 20020502
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.8632 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2817 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 86.32 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 128.17 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TABLET 1 1.3716 64720013010 20070601
004999 AMPHETAMINE SALTS 5 MG TABLET 1 137.16 64720013010 20070601
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 0.9621 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 1.2026 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 1.4285 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 96.21 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 120.26 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 142.85 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 0.9621 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.2026 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.4285 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 96.21 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 120.26 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 142.85 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.5993 57866707101 20031001
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 47.98 57866707101 20031001
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 0.9621 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.2026 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.4285 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 96.21 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 120.26 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 142.85 00555077502 20030319
What I need is
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.75 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TABLET 1 1.3716 64720013210 20070601
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 0.9621 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00406888601 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.1647 54868538700 20050811
gnc_seqno ln gni awp ndc NPT_DATEC
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.75 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TAB 1 112.5 23490797403 20071011
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.362 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.4525 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 36.2 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 45.25 63304090901 20070205
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9818 54868472805 20060210
005000 AMPHETAMINE SALTS 10 MG TAB 1 117.81 54868472805 20060210
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.0827 54868472804 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1494 54868472803 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2827 54868472801 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 2.016 54868472800 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 20.16 54868472800 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 38.48 54868472801 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 103.45 54868472803 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 108.27 54868472804 20050712
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1828 54868472802 20050623
005000 AMPHETAMINE SALTS 10 MG TAB 1 70.97 54868472802 20050623
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.3716 53489056601 20041119
005000 AMPHETAMINE SALTS 10 MG TAB 2 137.16 53489056601 20041119
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 63304090901 20041018
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 63304090901 20041018
005000 AMPHETAMINE SALTS 10 MG TAB 2 0.9238 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.1548 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 1.4285 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 92.38 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 115.48 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 2 142.85 53489056601 20040716
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00406889201 20040401
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 67767010301 20040101
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.204 54868472804 20031229
005000 AMPHETAMINE SALTS 10 MG TAB 1 320.4 54868472804 20031229
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3502 57866393502 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3633 57866393501 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 40.9 57866393501 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 121.52 57866393502 20031001
005000 AMPHETAMINE SALTS 10 MG TAB 1 2.9218 54868472802 20030321
005000 AMPHETAMINE SALTS 10 MG TAB 1 175.31 54868472802 20030321
005000 AMPHETAMINE SALTS 10 MG TAB 1 4.29 54868472800 20030120
005000 AMPHETAMINE SALTS 10 MG TAB 1 42.9 54868472800 20030120
005000 AMPHETAMINE SALTS 10 MG TAB 1 3.0217 54868472801 20030117
005000 AMPHETAMINE SALTS 10 MG TAB 1 90.65 54868472801 20030117
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9921 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2401 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.4287 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 99.21 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 124.01 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 142.87 63304090901 20020621
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00185011101 20020614
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00185011101 20020614
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.9238 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.1548 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.3716 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 92.38 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 115.48 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 137.16 00555097202 20020530
005000 AMPHETAMINE SALTS 10 MG TAB 1 0.8632 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 1.2817 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 86.32 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TAB 1 128.17 00555097202 20020211
005000 AMPHETAMINE SALTS 10 MG TABLET 1 1.3716 64720013210 20070601
005000 AMPHETAMINE SALTS 10 MG TABLET 1 137.16 64720013210 20070601
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 0.9621 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 1.2026 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 1.4285 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 96.21 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 120.26 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TAB 2 142.85 53489056701 20040716
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.2026 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.4285 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 96.21 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 120.26 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 142.85 00406888601 20040401
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.5993 57866707201 20031001
047132 AMPHETAMINE SALTS 12.5 MG TB 1 47.98 57866707201 20031001
047132 AMPHETAMINE SALTS 12.5 MG TB 1 0.9621 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.2026 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 1.4285 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 96.21 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 120.26 00555077602 20030319
047132 AMPHETAMINE SALTS 12.5 MG TB 1 142.85 00555077602 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.1647 54868538700 20050811
047133 AMPHETAMINE SALTS 15 MG TAB 1 104.82 54868538700 20050811
047133 AMPHETAMINE SALTS 15 MG TAB 2 0.9621 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 1.2026 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 1.4285 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 96.21 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 120.26 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 2 142.85 53489056801 20040716
047133 AMPHETAMINE SALTS 15 MG TAB 1 0.9621 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.2026 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.4285 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 96.21 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 120.26 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 142.85 00406888501 20040401
047133 AMPHETAMINE SALTS 15 MG TAB 1 0.9621 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.2026 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 1.4285 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 96.21 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 120.26 00555077702 20030319
047133 AMPHETAMINE SALTS 15 MG TAB 1 142.85 00555077702 20030319
005001 AMPHETAMINE SALTS 20 MG TAB 1 3.75 23490797506 20071011
005001 AMPHETAMINE SALTS 20 MG TAB 1 225 23490797506 20071011
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.362 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.4525 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 36.2 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 45.25 63304091001 20070205
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.716 54868510303 20050525
005001 AMPHETAMINE SALTS 20 MG TAB 1 34.32 54868510303 20050525
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.3716 53489056901 20041119
005001 AMPHETAMINE SALTS 20 MG TAB 2 137.16 53489056901 20041119
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1494 54868510302 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1828 54868510301 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.616 54868510300 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 48.48 54868510300 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 70.97 54868510301 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 103.45 54868510302 20041112
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 63304091001 20041018
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 63304091001 20041018
005001 AMPHETAMINE SALTS 20 MG TAB 2 0.9238 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.1548 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 1.4285 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 92.38 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 115.48 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 2 142.85 53489056901 20040716
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.2278 54868510301 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.9827 54868510300 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 89.48 54868510300 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 133.67 54868510301 20040709
005001 AMPHETAMINE SALTS 20 MG TAB 1 2.1946 54868510302 20040707
005001 AMPHETAMINE SALTS 20 MG TAB 1 197.51 54868510302 20040707
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00406889301 20040401
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 67767010601 20040101
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3469 57866393602 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.36 57866393601 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 40.8 57866393601 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 121.22 57866393602 20031001
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9921 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.2401 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.4287 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 99.21 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 124.01 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 142.87 63304091001 20020621
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00185040101 20020614
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00185040101 20020614
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.9238 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.1548 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.3716 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 92.38 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 115.48 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 137.16 00555097302 20020530
005001 AMPHETAMINE SALTS 20 MG TAB 1 0.8632 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 1.2817 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 86.32 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TAB 1 128.17 00555097302 20020211
005001 AMPHETAMINE SALTS 20 MG TABLET 1 1.3716 64720013510 20070601
005001 AMPHETAMINE SALTS 20 MG TABLET 1 137.16 64720013510 20070601
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.362 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.4525 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 36.2 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 45.25 63304091101 20070205
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.317 54868486300 20060623
034359 AMPHETAMINE SALTS 30 MG TAB 1 39.51 54868486300 20060623
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.3716 53489057001 20041119
034359 AMPHETAMINE SALTS 30 MG TAB 2 137.16 53489057001 20041119
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 63304091101 20041018
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 63304091101 20041018
034359 AMPHETAMINE SALTS 30 MG TAB 2 0.9238 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.1548 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 1.4285 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 92.38 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 115.48 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 2 142.85 53489057001 20040716
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00406889401 20040401
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 67767010701 20040101
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3469 57866394902 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.36 57866394901 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 40.8 57866394901 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 121.22 57866394902 20031001
034359 AMPHETAMINE SALTS 30 MG TAB 1 3.344 54868486300 20030725
034359 AMPHETAMINE SALTS 30 MG TAB 1 100.32 54868486300 20030725
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9921 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.2401 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.4287 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 99.21 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 124.01 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 142.87 63304091101 20020621
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00185040401 20020614
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00185040401 20020614
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.9238 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.1548 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.3716 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 92.38 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 115.48 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 137.16 00555097402 20020530
034359 AMPHETAMINE SALTS 30 MG TAB 1 0.8632 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 1.2817 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 86.32 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TAB 1 128.17 00555097402 20020211
034359 AMPHETAMINE SALTS 30 MG TABLET 1 1.3716 64720013610 20070601
034359 AMPHETAMINE SALTS 30 MG TABLET 1 137.16 64720013610 20070601
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.25 23490797303 20071011
004999 AMPHETAMINE SALTS 5 MG TAB 1 127.5 23490797303 20071011
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.362 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.4525 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 36.2 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 45.25 63304090801 20070205
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.516 54868463103 20050623
004999 AMPHETAMINE SALTS 5 MG TAB 1 90.96 54868463103 20050623
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.3716 53489056401 20041119
004999 AMPHETAMINE SALTS 5 MG TAB 2 137.16 53489056401 20041119
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 63304090801 20041018
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 63304090801 20041018
004999 AMPHETAMINE SALTS 5 MG TAB 2 0.9238 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.1548 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 1.4285 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 92.38 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 115.48 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 2 142.85 53489056401 20040716
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00406889101 20040401
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 67767010101 20040101
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3469 57866393402 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.36 57866393401 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 40.8 57866393401 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 121.22 57866393402 20031001
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.2118 54868463103 20030320
004999 AMPHETAMINE SALTS 5 MG TAB 1 252.71 54868463103 20030320
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.3443 54868463102 20030116
004999 AMPHETAMINE SALTS 5 MG TAB 1 100.33 54868463102 20030116
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00185008401 20020927
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00185008401 20020927
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9921 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2401 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.4287 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 99.21 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 124.01 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 142.87 63304090801 20020621
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.204 54868463100 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.4115 54868463101 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 88.23 54868463101 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 320.4 54868463100 20020605
004999 AMPHETAMINE SALTS 5 MG TAB 1 3.3702 54868463100 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 4.629 54868463101 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.58 54868463101 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 337.02 54868463100 20020604
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.9238 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.1548 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.3716 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 92.38 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 115.48 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 137.16 00555097102 20020530
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2819 00185008401 20020502
004999 AMPHETAMINE SALTS 5 MG TAB 1 128.19 00185008401 20020502
004999 AMPHETAMINE SALTS 5 MG TAB 1 0.8632 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 1.2817 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 86.32 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TAB 1 128.17 00555097102 20020211
004999 AMPHETAMINE SALTS 5 MG TABLET 1 1.3716 64720013010 20070601
004999 AMPHETAMINE SALTS 5 MG TABLET 1 137.16 64720013010 20070601
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 0.9621 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 1.2026 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 1.4285 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 96.21 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 120.26 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 2 142.85 53489056501 20040716
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 0.9621 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.2026 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.4285 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 96.21 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 120.26 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 142.85 00406888401 20040401
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.5993 57866707101 20031001
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 47.98 57866707101 20031001
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 0.9621 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.2026 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 1.4285 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 96.21 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 120.26 00555077502 20030319
047131 AMPHETAMINE SALTS 7.5 MG TAB 1 142.85 00555077502 20030319
SELECT RNDC14.gnc_seqno, RNDC14.ln, RNDC14.gni, RNP2.NPT_PRICEx AS awp, RNDC14.ndc, RNP2.NPT_DATEC
FROM RNP2 INNER JOIN
RNDC14 ON RNP2.NDC = RNDC14.ndc
WHERE (RNDC14.ln LIKE 'amphetamine salt%') AND (RNP2.NPT_PRICEx > 0)
GROUP BY RNDC14.gnc_seqno, RNDC14.ln, RNDC14.gni, RNP2.NPT_PRICEx, RNDC14.ndc, RNP2.NPT_DATEC
ORDER BY RNDC14.ln, RNP2.NPT_DATEC DESC, awp
SQL
Last Comment
THBA
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SELECT RNDC14.gnc_seqno, RNDC14.ln, RNDC14.gni, min(RNP2.NPT_PRICEx) AS awp, RNDC14.ndc, Max(RNP2.NPT_DATEC) as Mdate
FRom....