tablas de sql ejemplos sensillos

37
Página 1 de 37 TABLA 1 Descriptor Local Caja NroBoleta Fecha CodBarra ENALTEN-D 10/25 CAJA 30 COMP. 5 2 475416 12/17/2007 ### ENALTEN-D 10/25 CAJA 30 COMP. 5 2 475672 12/18/2007 ### LIFTER 100 MG. CAJA 5 COMP. 5 6 650898 12/17/2007 ### LIFTER 100 MG. CAJA 5 COMP. 5 7 23821 12/18/2007 ### LOMEX 20 MG. CAJA FCO. 35 CAP. 14 2 232654 12/18/2007 ### LOMEX 20 MG. CAJA FCO. 35 CAP. 14 7 230222 12/19/2007 ### HIDRIUM CAJA 20 COMP. 171 1 23317 12/18/2007 ### HIDRIUM CAJA 20 COMP. 171 1 23471 12/19/2007 ###

description

manera de subir en sql algunas consultas entre otro descargen para mejorar el sql

Transcript of tablas de sql ejemplos sensillos

Page 1: tablas de sql ejemplos sensillos

Página 1 de 31

TABLA 1

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

ENALTEN-D 10/25 CAJA 30 COMP. 5 2 475416 12/17/2007 7,800,060,405,684 4,300

ENALTEN-D 10/25 CAJA 30 COMP. 5 2 475672 12/18/2007 7,800,060,405,684 6,900

LIFTER 100 MG. CAJA 5 COMP. 5 6 650898 12/17/2007 7,800,060,113,121 10,840

LIFTER 100 MG. CAJA 5 COMP. 5 7 23821 12/18/2007 7,800,060,113,121 13,500

LOMEX 20 MG. CAJA FCO. 35 CAP. 14 2 232654 12/18/2007 7,800,060,117,211 9,170

LOMEX 20 MG. CAJA FCO. 35 CAP. 14 7 230222 12/19/2007 7,800,060,117,211 13,400

HIDRIUM CAJA 20 COMP. 171 1 23317 12/18/2007 7,800,060,009,912 2,450

HIDRIUM CAJA 20 COMP. 171 1 23471 12/19/2007 7,800,060,009,912 3,400

Page 2: tablas de sql ejemplos sensillos

Página 2 de 31

TABLA 2

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

FEMELLE CAJA 28 COMP. REC. 42 4 283990 28/12/2007 7800026050019 6,920

FEMELLE CAJA 28 COMP. REC. 240 5 169789 29/12/2007 7800026050019 8,900

DAL CAJA 28 COMP. 42 6 120904 28/12/2007 7800026030103 3,840

DAL CAJA 28 COMP. 5 8 279159 29/12/2007 7800026030103 5,800

GYNERA 75/20 CAJA 21 GRAG. 1 4 247790 12/27/2007 7,896,116,883,513 4,830

GYNERA 75/20 CAJA 21 GRAG. 1 10 414 12/28/2007 7,896,116,883,513 6,400

GYNERA CAJA 21 GRAG. 1 2 174581 12/27/2007 7,800,024,015,898 5,180

GYNERA CAJA 21 GRAG. 1 10 414 12/28/2007 7,800,024,015,898 6,200

MARVELON CAJA 21 COMP. 2 2 216277 12/27/2007 7,800,042,111,039 4,040

MARVELON CAJA 21 COMP. 2 4 224999 12/28/2007 7,800,042,111,039 6,240

BELARA CAJA 21 COMP. 1 8 14900 12/27/2007 7,800,055,907,810 6,730

BELARA CAJA 21 COMP. 1 10 412 12/28/2007 7,800,055,907,810 9,800

Page 3: tablas de sql ejemplos sensillos

Página 3 de 31

TABLA 3

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

TOBE 2,5 MG X 30 COMP.. 36 2 32983 12/27/2007 7,800,007,629,289 5,580

TOBE 2,5 MG X 30 COMP.. 36 2 33212 12/28/2007 7,800,007,629,289 8,900

LADY-TEN X 21 COMP REC UF 14 7 231196 12/27/2007 7,800,007,477,910 5,110

LADY-TEN X 21 COMP REC UF 14 8 187172 12/28/2007 7,800,007,477,910 6,800

TRITTICO 100 MG X 20 COMP. 2 4 224927 12/27/2007 7,800,007,100,146 6,470

TRITTICO 100 MG X 20 COMP. 2 4 225036 12/28/2007 7,800,007,100,146 8,200

POSIVYL 20MG X 30COMP. 1 2 174651 12/27/2007 7,800,007,431,172 11,820

POSIVYL 20MG X 30COMP. 1 10 414 12/28/2007 7,800,007,431,172 14,500

MARATHON X 30 CAPSULAS BLANDAS 134 3 350660 12/27/2007 7,800,007,401,502 3,490

MARATHON X 30 CAPSULAS BLANDAS 134 2 87390 12/28/2007 7,800,007,401,502 4,500

MARVELON-20 CAJA 21 COMP. 1 8 14940 12/27/2007 7,800,042,111,046 2,780

MARVELON-20 CAJA 21 COMP. 1 10 414 12/28/2007 7,800,042,111,046 6,240

CICLIDON-20 CAJA 21 COMP. REC. 70 6 30528 12/28/2007 7,800,026,017,616 2,860

CICLIDON-20 CAJA 21 COMP. REC. 70 2 481749 12/29/2007 7,800,026,017,616 4,900

CICLOMEX -15 CAJA 28 COMP. 292 4 180127 12/28/2007 7,800,026,211,014 2,660

CICLOMEX -15 CAJA 28 COMP. 8 5 252781 29/12/2007 7800026211014 4,900

CICLOMEX -20 CAJA 21 GRAG. 1 2 174773 12/28/2007 7,800,026,001,622 2,840

CICLOMEX -20 CAJA 21 GRAG. 5 2 478292 29/12/2007 7800026001622 5,400

CICLOMEX CAJA 21 COMP. REC. 1 10 412 12/28/2007 7,800,026,001,639 3,080

CICLOMEX CAJA 21 COMP. REC. 5 6 655685 29/12/2007 7800026001639 4,600

HEROLAN AEROSOL 10 ML 200 DOSIS 1 10 414 12/28/2007 7,800,007,112,316 3,160

HEROLAN AEROSOL 10 ML 200 DOSIS 5 7 27022 29/12/2007 7800007112316 5,900

FRENALER-D JARABE 100 ML 1 10 414 12/28/2007 7,800,007,403,636 2,070

FRENALER-D JARABE 100 ML 5 8 279145 29/12/2007 7800007403636 8,500

SINASMAL 100 MCG/DOSIS AEROSOL 10 ML 1 10 414 12/28/2007 7,800,007,323,286 2,150

SINASMAL 100 MCG/DOSIS AEROSOL 10 ML 5 6 655482 29/12/2007 7800007323286 5,600

Page 4: tablas de sql ejemplos sensillos

Página 4 de 31

TABLA 4

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

MALTOFER GTS. FRASCO 30 ML 11 8 231706 1/2/2008 7,800,018,117,218 2,760

MALTOFER GTS. FRASCO 30 ML 11 7 218818 1/3/2008 7,800,018,117,218 4,800

SPIRON 1 MG. CAJA 30 COMP. 234 8 166322 1/2/2008 7,800,018,129,006 6,610

SPIRON 1 MG. CAJA 30 COMP. 234 2 219789 1/3/2008 7,800,018,129,006 8,800

ANULETTE CAJA 21 COMP. 86 4 113564 1/2/2008 7,800,020,030,918 2,630

ANULETTE CAJA 21 COMP. 86 2 307455 1/3/2008 7,800,020,030,918 4,840

DRINA CAJA 21 COMP. 163 8 60056 1/2/2008 7,800,020,043,413 7,630

DRINA CAJA 21 COMP. 163 1 554745 1/3/2008 7,800,020,043,413 11,100

EMEZOL 40 MG 30 CAPS. 9 1 176407 1/2/2008 7,800,018,159,539 11,990

EMEZOL 40 MG 30 CAPS. 16 6 181568 1/3/2008 7,800,018,159,539 19,900

CIPRAMIL 20 MG. CAJA 28 COMP. 2 2 216818 1/2/2008 7,800,020,037,610 12,460

CIPRAMIL 20 MG. CAJA 28 COMP. 2 5 207484 1/3/2008 7,800,020,037,610 16,900

ELCAL-D CAJA 60 CAP. 133 1 379967 1/3/2008 7,800,034,518,204 3,180

ELCAL-D CAJA 60 CAP. 133 2 402630 1/4/2008 7,800,034,518,204 4,990

MALTOFER 100 MG. CAJA 30 COMP. 91 6 185066 1/3/2008 7,800,018,117,195 3,910

MALTOFER 100 MG. CAJA 30 COMP. 95 4 135403 1/4/2008 7,800,018,117,195 5,990

ELCAL-D FORTE CAJA 60 CAP. 74 3 69205 1/3/2008 7,800,018,123,356 3,030

ELCAL-D FORTE CAJA 60 CAP. 91 6 185172 1/4/2008 7,800,018,123,356 4,990

SPIRON 3 MG. CAJA 30 COMP. 300 2 163532 1/3/2008 7,800,018,122,229 14,630

SPIRON 3 MG. CAJA 30 COMP. 306 2 12941 1/4/2008 7,800,018,122,229 17,990

CITONEURON CAJA 30 CAP. 337 5 64909 1/3/2008 7,800,039,210,578 5,350

CITONEURON CAJA 30 CAP. 58 7 91319 1/4/2008 7,800,039,210,578 6,990

GAMALATE B6 CAJA 60 GRAG. 234 3 84435 1/3/2008 7,800,039,200,555 22,960

GAMALATE B6 CAJA 60 GRAG. 24 4 149806 1/4/2008 7,800,039,200,555 26,360

TAREG 80 MG. CAJA 28 CAP. 2 4 225866 1/3/2008 7,896,261,006,324 6,970

TAREG 80 MG. CAJA 28 CAP. 2 4 225999 1/4/2008 7,896,261,006,324 8,920

TAREG D 80/12,5 CAJA 28 COMP. 11 2 249754 1/3/2008 7,800,032,001,449 9,200

TAREG D 80/12,5 CAJA 28 COMP. 11 8 231925 1/4/2008 7,800,032,001,449 12,280

TAREG 160 MG. CAJA 28 CAP 36 3 105114 1/3/2008 7,896,261,006,379 10,100

TAREG 160 MG. CAJA 28 CAP 36 3 105217 1/4/2008 7,896,261,006,379 12,930

TRADOX 100 MG. CAJA 30 COMP. 22 2 275088 02/01/2008 7800018125244 25,220

Page 5: tablas de sql ejemplos sensillos

Página 5 de 31

TRADOX 100 MG. CAJA 30 COMP. 329 3 81382 1/4/2008 7,800,018,125,244 33,000

Page 6: tablas de sql ejemplos sensillos

Página 6 de 31

TABLA 5

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

FOLISANIN 5 MG. CAJA 30 COMP. 1 3 3956 1/7/2008 7,800,038,048,165 990

FOLISANIN 5 MG. CAJA 30 COMP. 1 7 226027 1/8/2008 7,800,038,048,165 2,490

FOLISANIN 1 MG. CAJA 30 COMP. 1 5 242746 1/7/2008 7,800,038,043,207 990

FOLISANIN 1 MG. CAJA 30 COMP. 1 7 226027 1/8/2008 7,800,038,043,207 1,930

TILDIEM 60 MG. CAJA 20 COMP. 1 5 242746 1/7/2008 7,800,041,047,322 2,200

TILDIEM 60 MG. CAJA 20 COMP. 1 7 226027 1/8/2008 7,800,041,047,322 4,950

ALDROX 70 MG. CAJA 10 COMP. REC. 202 8 641 1/7/2008 7,800,068,010,156 9,090

ALDROX 70 MG. CAJA 10 COMP. REC. 402 1 30579 1/8/2008 7,800,068,010,156 10,960

HIPOLIXAN 20 MG. CAJA 30 COMP. 67 1 557367 1/7/2008 7,800,068,012,471 14,700

HIPOLIXAN 20 MG. CAJA 30 COMP. 9 1 177398 1/8/2008 7,800,068,012,471 19,900

SELER UP 50 MG. 6 COMP. 1 3 4011 1/7/2008 7,800,068,120,022 7,870

SELER UP 50 MG. 6 COMP. 1 7 226027 1/8/2008 7,800,068,120,022 10,100

DORSOF T COL. FCO. 5ML 194 7 193383 1/8/2008 7,800,007,559,807 10,470

DORSOF T COL. FCO. 5ML 194 7 193494 1/9/2008 7,800,007,559,807 11,900

ZOMETIC 7.5 MG. CAJA 30 COMP. 1 7 226027 1/8/2008 7,800,041,047,414 2,320

ZOMETIC 7.5 MG. CAJA 30 COMP. 1 3 4276 1/9/2008 7,800,041,047,414 4,950

HIPOLIXAN 10 MG. CAJA 30 COMP. 1 7 226027 1/8/2008 7,800,068,012,488 8,200

HIPOLIXAN 10 MG. CAJA 30 COMP. 8 4 291243 1/9/2008 7,800,068,012,488 12,890

ALFIN 50 MG. CAJA 1 COMP. 5 7 29884 1/8/2008 7,800,038,040,251 1,470

ALFIN 50 MG. CAJA 1 COMP. 5 2 480731 1/9/2008 7,800,038,040,251 2,050

LOSOPIL 7.5 MG. CAJA 30 COMP. REC. 1 7 226027 1/8/2008 7,800,050,000,851 3,250

LOSOPIL 7.5 MG. CAJA 30 COMP. REC. 1 8 16165 1/9/2008 7,800,050,000,851 4,630

GRIFOPARKIN X 30 COMP. 13 7 376009 1/9/2008 7,800,007,103,406 6,510

GRIFOPARKIN X 30 COMP. 13 11 22082 1/10/2008 7,800,007,103,406 8,500

CORTIPREX 20 MG X 20 COMP. 22 2 276164 09/01/2008 7800007313645 3,710

CORTIPREX 20 MG X 20 COMP. 20 2 27118 10/01/2008 7800007313645 4,900

MORELIN X 30 COMP RECUB 171 5 83034 1/9/2008 7,800,007,104,991 3,240

MORELIN X 30 COMP RECUB 171 4 101782 1/10/2008 7,800,007,104,991 4,900

Page 7: tablas de sql ejemplos sensillos

Página 7 de 31

TABLA 6

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

TENSOLIV X 30 COMP RECUB 5 6 660080 08/01/2008 7800007152107 2,670

TENSOLIV X 30 COMP RECUB 8 4 291221 09/01/2008 7800007152107 3,900

AEROGASTROL CAJA 20 CAP. 3 4 182823 1/8/2008 7,800,050,300,012 2,280

AEROGASTROL CAJA 20 CAP. 3 4 183047 1/9/2008 7,800,050,300,012 4,140

DACAM RL X 1 FCO.AMP. 3 4 183012 1/9/2008 7,800,007,339,799 9,490

DACAM RL X 1 FCO.AMP. 3 6 38775 1/10/2008 7,800,007,678,492 10,900

Page 8: tablas de sql ejemplos sensillos

Página 8 de 31

TABLA 7

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

SIMPERTEN 50 MG X 30 COMP. 400 2 36883 1/15/2008 7,800,007,383,266 7,790

SIMPERTEN 50 MG X 30 COMP. 400 2 5312794 1/16/2008 7,800,007,383,266 9,800

AERIUS 5 MG. CAJA 30 COMP. 3 1 12387 1/15/2008 7,800,019,010,839 5,500

AERIUS 5 MG. CAJA 30 COMP. 3 6 39646 1/16/2008 7,800,019,010,839 8,990

NEOCLARITINE 5 MG. CAJA 30 COMP. 364 5 5619010 1/15/2008 7,800,089,016,397 5,740

NEOCLARITINE 5 MG. CAJA 30 COMP. 364 3 29169 1/16/2008 7,800,089,016,397 8,990

NASONEX 50 MCG. SUSP. NAS. 140 DOSIS 13 5 233698 1/16/2008 7,800,019,023,129 8,620

NASONEX 50 MCG. SUSP. NAS. 140 DOSIS 13 6 5715927 1/17/2008 7,800,019,023,129 14,990

UNICLAR 50 MCG. INH. NAS. 140 DOSIS 69 3 225056 1/16/2008 7,800,089,023,227 8,580

UNICLAR 50 MCG. INH. NAS. 140 DOSIS 69 2 304769 1/17/2008 7,800,089,023,227 14,990

Page 9: tablas de sql ejemplos sensillos

Página 9 de 31

TABLA 8

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

GLUCOPHAGE FORTE 850 MG. CAJA 60 COMP. 1 7 227365 1/23/2008 7,800,010,040,125 4,440

GLUCOPHAGE FORTE 850 MG. CAJA 60 COMP. 1 2 5014492 1/24/2008 7,800,010,040,125 6,990

GLUCOPHAGE FORTE 850 MG. CAJA 30 COMP 147 3 5527367 1/23/2008 7,800,010,040,101 4,130

GLUCOPHAGE FORTE 850 MG. CAJA 30 COMP 147 2 5527382 1/24/2008 7,800,010,040,101 4,690

GLAFORNIL 500 MG. CAJA 30 COMP. 1 8 17639 1/24/2008 3,596,540,040,103 1,830

GLAFORNIL 500 MG. CAJA 30 COMP. 1 4 249962 1/25/2008 3,596,540,040,103 2,990

Page 10: tablas de sql ejemplos sensillos

Página 10 de 31

TABLA 9

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

GYNERA 75/20 CAJA 21 GRAG. 3 1 13268 1/23/2008 7,896,116,883,513 6,400

GYNERA 75/20 CAJA 21 GRAG. 3 6 40509 1/24/2008 7,896,116,883,513 6,850

GYNERA CAJA 21 GRAG. 77 1 410217 1/23/2008 7,800,024,015,898 6,200

GYNERA CAJA 21 GRAG. 77 2 269200 1/24/2008 7,800,024,015,898 6,700

FEMINOL X 21 COMP. RECUB 85 3 265412 1/23/2008 7,800,007,355,997 3,900

FEMINOL X 21 COMP. RECUB 85 3 265553 1/24/2008 7,800,007,355,997 5,750

MARVELON-20 CAJA 21 COMP. 22 2 278355 1/23/2008 7,800,042,111,046 6,240

MARVELON-20 CAJA 21 COMP. 22 2 278367 1/24/2008 7,800,042,111,046 8,750

MARVELON CAJA 21 COMP. 37 1 343192 1/23/2008 7,800,042,111,039 6,240

MARVELON CAJA 21 COMP. 37 1 343364 1/24/2008 7,800,042,111,039 8,600

YASMIN CAJA 21 COMP. REC. 15 4 516228 1/24/2008 7,896,116,861,610 8,680

YASMIN CAJA 21 COMP. REC. 15 3 6582 1/25/2008 7,896,116,861,610 9,650

CICLIDON-20 CAJA 21 COMP. REC. 76 3 7423 1/24/2008 7,800,026,017,616 4,890

CICLIDON-20 CAJA 21 COMP. REC. 76 3 7528 1/25/2008 7,800,026,017,616 6,100

CICLOMEX -15 CAJA 28 COMP. 444 1 52665 1/24/2008 7,800,026,211,014 4,900

CICLOMEX -15 CAJA 28 COMP. 444 3 34981 1/25/2008 7,800,026,211,014 6,100

CICLOMEX -20 CAJA 21 GRAG. 464 2 10701 1/24/2008 7,800,026,001,622 5,400

CICLOMEX -20 CAJA 21 GRAG. 464 2 10790 1/25/2008 7,800,026,001,622 6,050

GYNOSTAT X 21 COMPRIMIDOS 20 7 348353 1/24/2008 7,800,007,404,015 4,700

GYNOSTAT X 21 COMPRIMIDOS 20 2 28747 1/25/2008 7,800,007,404,015 5,800

LIVIAL 2.5 MG. CAJA 28 COMP. 11 1 109928 1/24/2008 7,800,042,131,112 15,900

LIVIAL 2.5 MG. CAJA 28 COMP. 11 7 221060 1/25/2008 7,800,042,131,112 17,000

CONTI-MARVELON 20 CAJA 28 COMP.REC 350 2 97599 1/24/2008 7,800,042,000,128 7,870

CONTI-MARVELON 20 CAJA 28 COMP.REC 350 2 97786 1/25/2008 7,800,042,000,128 10,600

BELARA CAJA 21 COMP. 64 6 11122 1/24/2008 7,800,055,907,810 9,800

BELARA CAJA 21 COMP. 64 6 11192 1/25/2008 7,800,055,907,810 11,200

Page 11: tablas de sql ejemplos sensillos

Página 11 de 31

TABLA 10

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

LEROGIN CAJA 30 GRAG 15 4 517083 1/29/2008 7,800,026,016,558 4,370

LEROGIN CAJA 30 GRAG 15 4 517392 1/30/2008 7,800,026,016,558 8,450

TENSOLIV X 30 COMP RECUB 336 5 116678 1/29/2008 7,800,007,152,107 3,900

TENSOLIV X 30 COMP RECUB 336 5 116945 1/30/2008 7,800,007,152,107 5,600

VALCOTE 500 MG. CAJA 50 COMP. 347 3 55278 1/29/2008 7,800,009,000,628 18,390

VALCOTE 500 MG. CAJA 50 COMP. 347 4 58476 1/30/2008 7,800,009,000,628 22,990

ATEMPERATOR 200 MG. CAJA 30 COMP. 170 9 266714 1/29/2008 7,800,026,024,355 5,410

ATEMPERATOR 200 MG. CAJA 30 COMP. 170 6 65528 1/30/2008 7,800,026,024,355 7,990

VALCOTE ER 500 MG. CAJA 50 COMP. 2 2 220217 1/29/2008 7,790,440,712,627 20,210

VALCOTE ER 500 MG. CAJA 50 COMP. 2 2 220472 1/30/2008 7,790,440,712,627 24,990

DEPAKENE 250MG/5ML. JBE. FCO.120 ML. 350 2 98644 1/29/2008 7,800,009,745,253 7,480

DEPAKENE 250MG/5ML. JBE. FCO.120 ML. 350 2 98760 1/30/2008 7,800,009,745,253 9,990

LIBRAXIN CAJA 30 COMP. 43 5 240833 1/29/2008 7,798,009,273,688 6,560

LIBRAXIN CAJA 30 COMP. 43 3 216900 1/30/2008 7,798,009,273,688 8,750

ATEMPERATOR 500 MG. CAJA 20 COMP. 5 7 35456 1/30/2008 7,800,026,024,423 6,670

ATEMPERATOR 500 MG. CAJA 20 COMP. 59 1 46776 1/31/2008 7,800,026,024,423 9,990

VALCOTE 250 MG. CAJA 50 COMP. 33 1 159187 1/30/2008 7,800,009,000,611 12,320

VALCOTE 250 MG. CAJA 50 COMP. 35 4 42598 1/31/2008 7,800,009,000,611 15,990

VALCOTE 250 MG. CAJA 20 COMP. 304 7 5515255 1/30/2008 7,800,009,745,390 6,810

VALCOTE 250 MG. CAJA 20 COMP. 340 4 18036 1/31/2008 7,800,009,745,390 8,990

DAFLON-500 CAJA 60 COMP. 1 8 18127 1/30/2008 7,800,055,907,896 21,690

DAFLON-500 CAJA 60 COMP. 1 4 250312 1/31/2008 7,800,055,907,896 32,000

DIPEMINA 500 MG. CAJA 60 COMP 158 1 114070 1/30/2008 7,795,347,971,146 27,290

DIPEMINA 500 MG. CAJA 60 COMP 159 4 27694 1/31/2008 7,795,347,971,146 29,900

VALCOTE 500 MG. CAJA 20 COMP. 56 5 23789 1/31/2008 7,800,009,745,406 11,610

VALCOTE 500 MG. CAJA 20 COMP. 69 4 5723645 2/1/2008 7,800,009,745,406 13,990

Page 12: tablas de sql ejemplos sensillos

Página 12 de 31

TABLA 11

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

SPIRON 3 MG. CAJA 30 COMP. 14 7 236030 2/5/2008 7,800,018,122,229 17,990

SPIRON 3 MG. CAJA 30 COMP. 58 7 6101613 2/6/2008 7,800,018,122,229 20,500

MALTOFER JBE. FCO. 100 ML. 235 2 27690 2/5/2008 7,800,018,117,225 6,120

MALTOFER JBE. FCO. 100 ML. 236 5 504020 2/6/2008 7,800,018,117,225 8,120

SPIRON 1 MG. CAJA 30 COMP. 272 4 4890806 2/5/2008 7,800,018,129,006 8,800

SPIRON 1 MG. CAJA 30 COMP. 283 2 30558 2/6/2008 7,800,018,129,006 10,500

MALTOFER FOL CAJA 30 COMP. 149 4 523773 2/5/2008 7,800,018,117,201 6,850

MALTOFER FOL CAJA 30 COMP. 183 8 459094 2/6/2008 7,800,018,117,201 8,300

MALTOFER 100 MG. CAJA 30 COMP. 11 10 148542 2/6/2008 7,800,018,117,195 5,990

MALTOFER 100 MG. CAJA 30 COMP. 11 8 236426 2/7/2008 7,800,018,117,195 7,790

MALTOFER GTS. FRASCO 30 ML 69 3 228224 2/6/2008 7,800,018,117,218 4,800

MALTOFER GTS. FRASCO 30 ML 69 3 228376 2/7/2008 7,800,018,117,218 6,200

Page 13: tablas de sql ejemplos sensillos

Página 13 de 31

TABLA 12

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

ATEMPERATOR 500 MG. CAJA 20 COMP. 17 4 24584 2/18/2008 7,800,026,024,423 9,990

ATEMPERATOR 500 MG. CAJA 20 COMP. 28 2 385605 2/19/2008 7,800,026,024,423 10,290

ZYPREXA 5 MG. CAJA 14 COMP. 42 6 5709126 2/18/2008 7,795,990,000,873 19,070

ZYPREXA 5 MG. CAJA 14 COMP. 72 7 172066 2/19/2008 7,795,990,000,873 27,790

IPRAN 10 MG. CAJA 30 COMP. REC. 19 5 65502 2/18/2008 7,800,026,020,364 10,630

IPRAN 10 MG. CAJA 30 COMP. REC. 19 5 65693 2/19/2008 7,800,026,020,364 14,400

EBIXA 10 MG. CAJA 56 COMP. REC. 33 4 400425 2/18/2008 7,798,092,890,182 24,950

EBIXA 10 MG. CAJA 56 COMP. REC. 33 4 400592 2/19/2008 7,798,092,890,182 32,900

PLEXUS JBE. FCO. 120 ML. 238 3 61905 2/18/2008 7,800,026,009,758 4,060

PLEXUS JBE. FCO. 120 ML. 241 3 347873 2/19/2008 7,800,026,009,758 4,270

ZYPREXA 10 MG. CAJA 28 COMP. 32 3 32369 2/18/2008 7,795,990,000,934 87,690

ZYPREXA 10 MG. CAJA 28 COMP. 43 5 245432 2/19/2008 7,795,990,000,934 114,900

ZYPREXA ZYDIS 5 MG. 7 COMP. 224 2 260048 2/18/2008 7,795,990,001,528 13,310

ZYPREXA ZYDIS 5 MG. 7 COMP. 235 4 382758 2/19/2008 7,795,990,001,528 15,990

CORODIN 50 MG. CAJA 30 COMP. 8 5 259311 2/19/2008 7,800,026,016,190 9,210

CORODIN 50 MG. CAJA 30 COMP. 8 4 298090 2/20/2008 7,800,026,016,190 12,890

IPRAN 20 MG. CAJA 30 COMP. REC. 191 6 35821 2/19/2008 7,800,026,025,383 22,090

IPRAN 20 MG. CAJA 30 COMP. REC. 202 12 129363 2/20/2008 7,800,026,025,383 24,900

CORODIN-D CAJA 30 COMP. 2 3 196942 2/19/2008 7,800,026,016,183 5,630

CORODIN-D CAJA 30 COMP. 2 2 223511 2/20/2008 7,800,026,016,183 8,190

PROZAC 20 MG. CAJA 28 COMP. DISPERSABLES 35 2 229353 2/19/2008 7,800,067,015,725 16,220

PROZAC 20 MG. CAJA 28 COMP. DISPERSABLES 35 4 47768 2/20/2008 7,800,067,015,725 22,800

DIXI-35 CAJA 21 COMP. REC. 3 2 225740 2/19/2008 7,800,026,009,222 6,850

DIXI-35 CAJA 21 COMP. REC. 3 3 499887 2/20/2008 7,800,026,009,222 9,790

Page 14: tablas de sql ejemplos sensillos

Página 14 de 31

TABLA 13

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

ELCAL-D CAJA 60 CAP. 230 5 198940 2/19/2008 7,800,034,518,204 4,990

ELCAL-D CAJA 60 CAP. 230 2 170295 2/20/2008 7,800,034,518,204 6,590

ELCAL-D FORTE CAJA 60 CAP. 11 10 150094 2/19/2008 7,800,018,123,356 4,990

ELCAL-D FORTE CAJA 60 CAP. 11 8 238188 2/20/2008 7,800,018,123,356 6,590

MALTOFER GTS. FRASCO 30 ML 14 2 240286 2/20/2008 7,800,018,117,218 6,200

MALTOFER GTS. FRASCO 30 ML 15 4 521269 2/21/2008 7,800,018,117,218 6,650

ELCAL-D CAJA 30 CAP. 142 6 451867 2/20/2008 7,800,034,515,982 3,900

ELCAL-D CAJA 30 CAP. 142 5 433914 2/21/2008 7,800,034,515,982 4,280

ARATAN 50 MG. CAJA 30 COMP. 134 3 5452651 2/20/2008 7,800,018,121,918 11,990

ARATAN 50 MG. CAJA 30 COMP. 134 2 5452672 2/21/2008 7,800,018,121,918 13,510

Page 15: tablas de sql ejemplos sensillos

Página 15 de 31

TABLA 14

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

LYRICA 75MG CAJA 28 CAPS. 142 5 435108 2/27/2008 7,800,001,001,852 10,000

LYRICA 75MG CAJA 28 CAPS. 142 5 435435 2/28/2008 7,800,001,001,852 14,800

XALATAN 0.005% COL. FCO. 2.5 ML. 22 3 219153 2/27/2008 7,317,962,960,222 9,990

XALATAN 0.005% COL. FCO. 2.5 ML. 33 6 23358 2/28/2008 7,317,962,960,222 13,800

LIPITOR 10 MG. CAJA 30 COMP. 3 3 501339 2/27/2008 7,702,134,104,946 10,910

LIPITOR 10 MG. CAJA 30 COMP. 11 4 67641 2/28/2008 7,702,134,104,946 16,800

CARDURA XL 4 MG. CAJA 30 COMP. 40 3 110891 2/27/2008 7,800,001,950,198 10,680

CARDURA XL 4 MG. CAJA 30 COMP. 40 2 3146817 2/28/2008 7,800,001,950,198 14,000

NORVASC 5 MG. CAJA 30 COMP. 121 6 250204 2/27/2008 7,800,001,900,209 9,900

NORVASC 5 MG. CAJA 30 COMP. 121 4 114813 2/28/2008 7,800,001,900,209 15,200

LIPITOR 20 MG. CAJA 60 COMP.REC 234 8 176611 2/27/2008 7,702,134,314,659 29,100

LIPITOR 20 MG. CAJA 60 COMP.REC 234 3 86769 2/28/2008 7,702,134,314,659 36,000

NORMATOL 300 MG. CAJA 30 CAP. 84 3 236282 2/27/2008 7,800,002,009,802 17,270

NORMATOL 300 MG. CAJA 30 CAP. 192 2 148821 2/28/2008 7,800,002,009,802 21,800

CADUET 10MG/10MG CAJA 30 COMP. REC 230 3 21059 2/27/2008 7,800,001,001,890 24,180

CADUET 10MG/10MG CAJA 30 COMP. REC 261 2 112177 2/28/2008 7,800,001,001,890 28,000

ALTRULINE 100 MG. CAJA 30 COMP. 11 1 112775 2/27/2008 7,800,001,900,407 28,690

ALTRULINE 100 MG. CAJA 30 COMP. 11 8 239209 2/28/2008 7,800,001,900,407 34,200

CELEBRA 200 MG. CAJA 30 CAP 37 11 66192 2/27/2008 7,800,001,900,384 19,960

CELEBRA 200 MG. CAJA 30 CAP 43 2 5967301 2/28/2008 7,800,001,900,384 22,400

CELEBRA 200 MG. CAJA 10 CAP. 229 6 225676 2/28/2008 7,800,001,900,346 4,650

CELEBRA 200 MG. CAJA 10 CAP. 229 4 185068 2/29/2008 7,800,001,900,346 7,140

LIPITOR 10 MG. CAJA 60 COMP. 283 5 201224 2/28/2008 7,702,134,314,567 18,990

LIPITOR 10 MG. CAJA 60 COMP. 283 4 220988 2/29/2008 7,702,134,314,567 26,040

MEDROL 16 MG. CAJA 14 COMP. 259 2 305222 2/28/2008 7,800,022,000,247 13,740

MEDROL 16 MG. CAJA 14 COMP. 275 5 328535 2/29/2008 7,800,022,000,247 18,690

NORVASC 10 MG. CAJA 30 COMP. 228 7 213392 2/28/2008 7,800,001,700,069 14,510

NORVASC 10 MG. CAJA 30 COMP. 228 8 208202 2/29/2008 7,800,001,700,069 21,840

ALTRULINE 50 MG CAJA 30 COMP. 33 4 402085 2/28/2008 7,800,001,900,193 17,000

ALTRULINE 50 MG CAJA 30 COMP. 58 7 100537 2/29/2008 7,800,001,900,193 21,840

LIPITOR 40 MG. CAJA 30 COMP. 444 3 39175 2/28/2008 7,702,134,185,662 21,780

LIPITOR 40 MG. CAJA 30 COMP. 466 4 34891 2/29/2008 7,702,134,185,662 30,240

CADUET 5MG/10MG CAJA 30 COMP. REC. 201 7 384247 2/28/2008 7,800,001,001,883 18,980

CADUET 5MG/10MG CAJA 30 COMP. REC. 214 2 533833 2/29/2008 7,800,001,001,883 25,410

LIPITOR 20 MG. CAJA 30 COMP. 149 7 5722039 2/28/2008 7,702,134,362,582 26,290

Page 16: tablas de sql ejemplos sensillos

Página 16 de 31

LIPITOR 20 MG. CAJA 30 COMP. 154 7 353314 2/29/2008 7,702,134,362,582 33,600

Page 17: tablas de sql ejemplos sensillos

Página 17 de 31

TABLA 15

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

VALCOTE ER 500 MG. CAJA 50 COMP. 337 3 53171 3/3/2008 7,790,440,712,627 24,990

VALCOTE ER 500 MG. CAJA 50 COMP. 337 2 9240 3/4/2008 7,790,440,712,627 28,750

ATEMPERATOR 500 MG. CAJA 20 COMP. 81 1 468517 3/3/2008 7,800,026,024,423 10,290

ATEMPERATOR 500 MG. CAJA 20 COMP. 84 3 236680 3/4/2008 7,800,026,024,423 14,100

NEURACTIN 500 MG. CAJA 20 COMP. 13 11 24266 3/3/2008 7,800,026,020,739 7,340

NEURACTIN 500 MG. CAJA 20 COMP. 13 10 116160 3/4/2008 7,800,026,020,739 8,500

ATEMPERATOR 250 MG. CAJA 20 COMP. 337 3 53395 04/03/2008 7800026024416 4,500

ATEMPERATOR 250 MG. CAJA 20 COMP.Obs: Atemperator sin venta 5/03/2008

NEURACTIN SR 500 MG. CAJA 50 COMP. 202 7 66043 03/03/2008 7800026003244 26,810

NEURACTIN SR 500 MG. CAJA 50 COMP. 84 2 247148 3/5/2008 7,800,026,003,244 29,000Obs: Neuractin sin venta 4/03/2008

CONDROSULF 800 MG. CAJA 30 COMP. 2 5 212442 3/4/2008 7,804,907,000,056 12,860

CONDROSULF 800 MG. CAJA 30 COMP. 2 5 212549 3/5/2008 7,804,907,000,056 16,000

Page 18: tablas de sql ejemplos sensillos

Página 18 de 31

TABLA 16

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

PLAVIX 75 MG. CAJA 28 COMP. 123 5 117365 3/5/2008 7,800,058,205,005 35,900

PLAVIX 75 MG. CAJA 28 COMP. 123 1 224226 3/6/2008 7,800,058,205,005 39,800

BETACAR 50 MG. CAJA 20 COMP. 11 8 240152 3/6/2008 7,800,058,550,013 4,110

BETACAR 50 MG. CAJA 20 COMP. 11 8 240293 3/7/2008 7,800,058,550,013 4,980

Page 19: tablas de sql ejemplos sensillos

Página 19 de 31

TABLA 17

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

NEXIUM 40 MG 28 COMP 2 4 234400 3/11/2008 7,321,831,621,930 11,670

NEXIUM 40 MG 28 COMP 2 3 199754 3/12/2008 7,321,831,621,930 23,990

NEXIUM 20 MG 28 COMP. 2 2 226133 3/11/2008 7,321,831,621,886 6,850

NEXIUM 20 MG 28 COMP. 2 5 213443 3/12/2008 7,321,831,621,886 12,500

TOBE 2,5 MG X 30 COMP.. 1 7 232076 3/12/2008 7,800,007,629,289 8,900

TOBE 2,5 MG X 30 COMP.. 1 10 1725 3/13/2008 7,800,007,629,289 10,500

Page 20: tablas de sql ejemplos sensillos

Página 20 de 31

TABLA 18

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

DILATREND 25 MG. CAJA 28 COMP. 5 5 605212 3/12/2008 7,800,010,006,954 9,900

DILATREND 25 MG. CAJA 28 COMP. 5 6 683966 3/13/2008 7,800,010,006,954 13,900

DILATREND 12.5 MG. CAJA 28 COMP. 33 1 161897 3/12/2008 7,800,010,001,928 8,400

DILATREND 12.5 MG. CAJA 28 COMP. 33 6 26578 3/13/2008 7,800,010,001,928 10,400

DORMONID 15 MG. CAJA 30 COMP. 159 6 239668 3/12/2008 7,896,226,502,953 7,510

DORMONID 15 MG. CAJA 30 COMP. 159 6 239847 3/13/2008 7,896,226,502,953 12,990

DILATREND 6.25 MG. CAJA 28 COMP. 55 1 95168 3/12/2008 7,800,010,001,911 6,320

DILATREND 6.25 MG. CAJA 28 COMP. 55 2 318276 3/13/2008 7,800,010,001,911 7,990

RAVOTRIL 0.5 MG. CAJA 28 COMP 1 8 22404 3/13/2008 7,730,486,729,586 3,490

RAVOTRIL 0.5 MG. CAJA 28 COMP 1 7 232326 3/14/2008 7,730,486,729,586 3,990

RAVOTRIL 1 MG CAJA 28 COMP. 8 1 306727 3/13/2008 7,730,486,729,791 4,980

RAVOTRIL 1 MG CAJA 28 COMP. 8 6 496190 3/14/2008 7,730,486,729,791 5,790

RAVOTRIL 2 MG CAJA 28COMP 1 8 22329 3/13/2008 7,730,486,729,807 6,990

RAVOTRIL 2 MG CAJA 28COMP 1 7 232224 3/14/2008 7,730,486,729,807 7,990

CONFER CAJA 30 CAP. 1 6 171967 3/17/2008 7,800,017,065,435 5,310

CONFER CAJA 30 CAP. 1 8 22812 3/18/2008 7,800,017,065,435 7,490

AMOVAL 500MG/5ML SUSP. FCO. 100 ML. 5 6 685523 3/17/2008 7,800,060,111,349 4,950

AMOVAL 500MG/5ML SUSP. FCO. 100 ML. 5 2 490588 3/18/2008 7,800,060,111,349 6,900

TREX 500 MG. CAJA 6 COMP. 125 2 44373 3/17/2008 7,800,060,410,091 11,360

TREX 500 MG. CAJA 6 COMP. 125 3 50425 3/18/2008 7,800,060,410,091 15,890

AMOVAL 1 GR. CAJA 14 COMP. 5 8 291644 3/17/2008 7,800,060,111,189 5,180

AMOVAL 1 GR. CAJA 14 COMP. 5 8 291909 3/18/2008 7,800,060,111,189 6,390

TAREG 80 MG. CAJA 28 CAP. 401 2 5973655 3/17/2008 7,896,261,006,324 8,920

TAREG 80 MG. CAJA 28 CAP. 401 1 13524 3/18/2008 7,896,261,006,324 16,000

Page 21: tablas de sql ejemplos sensillos

Página 21 de 31

TABLA 19

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

TAREG D 160/12.5 CAJA 28 COMP. 3 6 6094729 3/13/2008 7,800,032,001,715 8,620

TAREG D 160/12.5 CAJA 28 COMP. 3 3 504354 3/14/2008 7,800,032,001,715 14,000

LIFTER 100 MG. CAJA 5 COMP. 1 7 232131 3/13/2008 7,800,060,113,121 13,500

LIFTER 100 MG. CAJA 5 COMP. 1 6 171878 3/14/2008 7,800,060,113,121 15,940

REFLEXAN 5 MG. CAJA 20 COMP. REC. 2 4 234643 3/13/2008 7,800,059,118,151 1,460

REFLEXAN 5 MG. CAJA 20 COMP. REC. 2 2 226472 3/14/2008 7,800,059,118,151 2,990

TREX 500 MG. CAJA 3 COMP. 8 6 496068 3/13/2008 7,800,060,407,466 7,540

TREX 500 MG. CAJA 3 COMP. 8 6 496212 3/14/2008 7,800,060,407,466 9,490

AMOVAL-21 500 MG. CAJA 21 COMP. 228 10 151366 3/13/2008 7,800,060,017,245 5,800

AMOVAL-21 500 MG. CAJA 21 COMP. 228 10 151568 3/14/2008 7,800,060,017,245 6,600

FLEMEX J.A.T. FORTE JBE. FCO.120 ML. 5 8 291794 3/17/2008 7,800,026,025,499 5,260

FLEMEX J.A.T. FORTE JBE. FCO.120 ML. 5 6 685896 3/18/2008 7,800,026,025,499 8,300

SOMNO 10 MG. CAJA 30 COMP. 8 6 5962904 3/17/2008 7,800,060,413,511 11,490

SOMNO 10 MG. CAJA 30 COMP. 8 6 496928 3/18/2008 7,800,060,413,511 15,490

Page 22: tablas de sql ejemplos sensillos

Página 22 de 31

TABLA 20

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

MICROGYNON-CD CAJA 28 GRAG. 11 1 106156 12/11/2007 7,896,116,861,078 1,550

MICROGYNON-CD CAJA 28 GRAG. 11 7 216410 12/12/2007 7,896,116,861,078 2,240

DINAFLEX 400 MG. CAJA 6 AMP. 1 ML 58 2 302513 18/12/2007 7800070001814 3,740

DINAFLEX 400 MG. CAJA 6 AMP. 1 ML 20 6 157839 19/12/2007 7800070001814 3,740

ZOMETIC 7.5 MG. CAJA 30 COMP. 2 3 191412 08/01/2008 7800041047414 2,320

ZOMETIC 7.5 MG. CAJA 30 COMP. 43 2 264485 09/01/2008 7800041047414 4,950

CLARIMAX 250 MG/5ML. SUSP. FCO. 80 ML. 3 3 497035 2/6/2008 7,800,018,150,765 9,330

CLARIMAX 250 MG/5ML. SUSP. FCO. 80 ML. 37 3 175772 2/7/2008 7,800,018,150,765 10,990

Page 23: tablas de sql ejemplos sensillos

Página 23 de 31

TABLA 21

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

AEROLIN LF 100 MCG. INH. BUC. 200 DOSIS 8 4 289988 1/2/2008 7,800,029,002,480 3,670

AEROLIN LF 100 MCG. INH. BUC. 200 DOSIS 8 6 484385 1/3/2008 7,800,029,002,480 5,400

FLIXOTIDE LF 125 MCG. INH. BUC. 120DOSIS 69 5 112572 1/2/2008 7,800,029,002,602 15,100

FLIXOTIDE LF 125 MCG. INH. BUC. 120DOSIS 124 3 272010 1/3/2008 7,800,029,002,602 21,640

FEMINOL X 21 COMP. RECUB 1 7 225033 12/27/2007 7,800,007,355,997 3,210

FEMINOL X 21 COMP. RECUB 1 10 412 12/28/2007 7,800,007,355,997 3,900

FLIXONASE 0.05% SUSP. AER. 120 DOS.NAS. 1 10 412 12/28/2007 7,800,029,000,271 12,960

FLIXONASE 0.05% SUSP. AER. 120 DOS. NAS. 11 16 17192 29/12/2008 7800029000271 17,590

LIVIAL 2.5 MG. CAJA 28 COMP. 8 1 296108 12/27/2007 7,800,042,131,112 11,050

LIVIAL 2.5 MG. CAJA 28 COMP. 8 6 483545 12/28/2007 7,800,042,131,112 15,900

SIMPERTEN D 100 MG CAJA 30 COMP. 1 10 399 12/28/2007 7,800,007,629,449 6,920

SIMPERTEN D 100 MG CAJA 30 COMP. 41 2 216623 12/29/2007 7,800,007,629,449 8,500

GYNOSTAT 20 21C 13 7 374920 12/27/2007 7,800,007,422,422 3,450

GYNOSTAT 20 21C 13 11 21246 12/28/2007 7,800,007,422,422 4,700

FESEMA LF 100 MCG. INH. BUC. 200 DOSIS 212 4 176906 12/29/2007 7,800,030,005,449 2,800

FESEMA LF 100 MCG. INH. BUC. 200 DOSIS 305 2 127335 12/30/2007 7,800,030,005,449 4,600

LAMICTAL 100 MG. CAJA 30 COMP. 91 6 184878 1/2/2008 7,800,029,001,384 24,490

LAMICTAL 100 MG. CAJA 30 COMP. 91 5 252506 1/3/2008 7,800,029,001,384 31,900

TRAVIATA 20 MG. CAJA 30 COMP. 1 10 493 03/01/2008 7800018125114 17,120

TRAVIATA 20 MG. CAJA 30 COMP. 1 2 175177 04/01/2008 7800018125114 21,570

HIPOLIXAN 40 MG. CAJA 30 COMP. 1 7 226027 1/8/2008 7,800,068,012,457 22,550

HIPOLIXAN 40 MG. CAJA 30 COMP. 12 2 80405 1/9/2008 7,800,068,012,457 22,990

PRODEL 4 MG. CAJA 20 COMP. 188 1 108936 1/22/2008 7,800,068,014,123 1,690

PRODEL 4 MG. CAJA 20 COMP. 192 2 145396 1/23/2008 7,800,068,014,123 2,100

ANISIMOL 20 MG. CAJA 20 COMP. 1 7 226027 08/01/2008 7800050306410 2,450

ANISIMOL 20 MG. CAJA 20 COMP. 9 1 177536 09/01/2008 7800050306410 3,200

CONPREMIN 0.3 MG. CAJA 28 GRAG. 43 5 239283 22/01/2008 7800033081044 5,540

CONPREMIN 0.3 MG. CAJA 28 GRAG. 11 1 109860 23/01/2008 7800033081044 10,370

RAVOTRIL 0.5 MG. CAJA 28 COMP 2 4 228380 1/22/2008 7,730,486,729,586 2,800

RAVOTRIL 0.5 MG. CAJA 28 COMP 2 5 209479 1/23/2008 7,730,486,729,586 3,490

RAVOTRIL 1 MG CAJA 28 COMP. 8 1 299803 1/22/2008 7,730,486,729,791 3,860

RAVOTRIL 1 MG CAJA 28 COMP. 8 1 299955 1/23/2008 7,730,486,729,791 4,980

RAVOTRIL 2 MG CAJA 28COMP 2 2 219382 1/22/2008 7,730,486,729,807 5,940

RAVOTRIL 2 MG CAJA 28COMP 2 4 228523 1/23/2008 7,730,486,729,807 6,990

DILATREND 25 MG. CAJA 28 COMP. 2 2 219631 1/24/2008 7,800,010,006,954 6,900

Page 24: tablas de sql ejemplos sensillos

Página 24 de 31

TABLA 21

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

DILATREND 25 MG. CAJA 28 COMP. 2 3 193637 1/25/2008 7,800,010,006,954 9,900

DAL CAJA 28 COMP. 17 5 23381 1/23/2008 7,800,026,030,103 5,800

DAL CAJA 28 COMP. 17 5 23566 1/24/2008 7,800,026,030,103 7,100

EUTIROX 100 MCG. CAJA 100 COMP. 1 3 5405 1/23/2008 4,022,536,876,849 3,750

EUTIROX 100 MCG. CAJA 100 COMP. 1 3 5014498 1/24/2008 4,022,536,876,849 5,400

EUTIROX 50 MCG. CAJA 50 COMP. 1 7 227359 1/23/2008 4,022,536,980,720 2,200

EUTIROX 50 MCG. CAJA 50 COMP. 1 8 17636 1/24/2008 4,022,536,980,720 3,250

EUTIROX 75 MCG. CAJA 50 COMP. 1 8 5014482 1/23/2008 4,022,536,980,737 2,540

EUTIROX 75 MCG. CAJA 50 COMP. 1 2 5014496 1/24/2008 4,022,536,980,737 3,570

FEMELLE 20 CAJA 28 COMP.RECUBIERTO 5 2 482627 1/23/2008 7,800,026,005,989 7,520

FEMELLE 20 CAJA 28 COMP.RECUBIERTO 5 6 666376 1/24/2008 7,800,026,005,989 10,500

FEMELLE CAJA 28 COMP. REC. 14 8 189763 1/23/2008 7,800,026,050,019 8,900

FEMELLE CAJA 28 COMP. REC. 14 3 214905 1/24/2008 7,800,026,050,019 10,200

PLAVIX 75 MG. CAJA 28 COMP. 11 1 109932 1/24/2008 7,800,058,205,005 30,920

PLAVIX 75 MG. CAJA 28 COMP. 11 8 234652 1/25/2008 7,800,058,205,005 35,900

DILATREND 12.5 MG. CAJA 28 COMP. 67 1 5082966 1/24/2008 7,800,010,001,928 5,200

DILATREND 12.5 MG. CAJA 28 COMP. 67 1 560943 1/25/2008 7,800,010,001,928 8,400

CONDROSULF 800 MG. CAJA 30 COMP. 3 3 495012 1/28/2008 7,804,907,000,056 11,220

CONDROSULF 800 MG. CAJA 30 COMP. 3 2 223273 1/29/2008 7,804,907,000,056 15,150

SULPILAN 50 MG. CAJA 30 CAP. 2 4 229417 1/29/2008 7,804,907,010,901 5,070

SULPILAN 50 MG. CAJA 30 CAP. 2 4 229556 1/30/2008 7,804,907,010,901 6,280

ACTONEL 35 MG. CAJA 4 COMP. 58 2 313890 3/6/2008 7,795,312,020,428 18,490

ACTONEL 35 MG. CAJA 4 COMP. 58 2 314056 3/7/2008 7,795,312,020,428 24,490

SPIRON 1MG/ML. SOL. FCO. 30 ML. 202 9 275728 10/03/2008 7800018124148 13,370

SPIRON 1MG/ML. SOL. FCO. 30 ML. 11 10 152534 11/03/2008 7800018124148 15,990

IPRAN 10 MG. CAJA 30 COMP. REC. 5 2 490359 17/03/2008 7800026020364 14,400

IPRAN 10 MG. CAJA 30 COMP. REC. 8 2 136172 18/03/2008 7800026020364 17,900

IPRAN 20 MG. CAJA 30 COMP. REC. 15 3 13934 18/03/2008 7800026025383 24,900

IPRAN 20 MG. CAJA 30 COMP. REC. 202 9 276415 19/03/2008 7800026025383 29,900

RECAMICINA 500 MG. CAJA 10 COMP. 5 9 90486 3/18/2008 7,800,026,009,826 8,150

RECAMICINA 500 MG. CAJA 10 COMP. 5 7 48100 3/19/2008 7,800,026,009,826 13,200

SINASMAL 100 MCG/DOSIS AEROSOL 10 ML 81 1 471119 3/18/2008 7,800,007,323,286 3,500

SINASMAL 100 MCG/DOSIS AEROSOL 10 ML 81 5 142772 3/19/2008 7,800,007,323,286 4,490

LEXAPRO 10 MG. CAJA 28 COMP. 1 5 248828 3/18/2008 7,798,092,890,137 18,900

Page 25: tablas de sql ejemplos sensillos

Página 25 de 31

TABLA 21

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

LEXAPRO 10 MG. CAJA 28 COMP. 1 4 254975 3/19/2008 7,798,092,890,137 22,900

HEROLAN AEROSOL 10 ML 200 DOSIS 1 3 9096 3/26/2008 7,800,007,112,316 6,500

HEROLAN AEROSOL 10 ML 200 DOSIS 1 10 2384 3/27/2008 7,800,007,112,316 7,500

D-HISTAPLUS 5 MG. 30 COMP. 8 6 486410 1/15/2008 7,800,068,010,187 5,990

D-HISTAPLUS 5 MG. 30 COMP. 8 1 299081 1/16/2008 7,800,068,010,187 8,290

URSOFALK 250 MG. CAJA 100 CAP. 284 2 200349 3/10/2008 7,800,014,020,000 41,270

URSOFALK 250 MG. CAJA 100 CAP. 396 2 64770 3/11/2008 7,800,014,020,000 48,890

SALOFALK 500 MG. CAJA 100 COMP. 77 2 273932 3/10/2008 7,800,014,020,307 38,390

SALOFALK 500 MG. CAJA 100 COMP. 77 1 418187 3/11/2008 7,800,014,020,307 45,890

Page 26: tablas de sql ejemplos sensillos

Página 26 de 31

TABLA 22

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

DEGRALER 5 MG. CAJA 30 COMP. REC. 5 2 473984 12/11/2007 7,800,028,000,982 4,350

DEGRALER 5 MG. CAJA 30 COMP. REC. 5 8 275224 12/12/2007 7,800,028,000,982 6,900

REMITEX 10 MG. CAJA 30 COMP. 84 3 227990 12/11/2007 7,800,028,841,561 7,640

REMITEX 10 MG. CAJA 30 COMP. 84 3 228113 12/12/2007 7,800,028,841,561 9,900

LAMICTAL 50 MG. CAJA 30 COMP. 410 1 27893 1/2/2008 7,800,029,001,377 16,170

LAMICTAL 50 MG. CAJA 30 COMP. 410 1 28060 1/3/2008 7,800,029,001,377 19,500

EFEXOR XR 75 MG. CAJA 30 CAP. 2 2 219527 1/23/2008 7,800,033,080,870 20,990

EFEXOR XR 75 MG. CAJA 30 CAP. 8 4 293849 1/24/2008 7,800,033,080,870 35,590

MOBEX 15 MG. CAJA 10 COMP. 1 8 22776 3/17/2008 7,795,304,000,476 5,460

MOBEX 15 MG. CAJA 10 COMP. 1 8 22828 3/18/2008 7,795,304,000,476 6,200

MIGRANOL CAJA 10 COMP. 1 6 172006 3/17/2008 7,800,028,000,357 1,090

MIGRANOL CAJA 10 COMP. 1 7 232641 3/18/2008 7,800,028,000,357 1,350

YASMIN CAJA 21 COMP. REC. 1 5 240664 12/12/2007 7,896,116,861,610 5,990

YASMIN CAJA 21 COMP. REC. 1 2 173678 12/13/2007 7,896,116,861,610 8,680

ARATAN 50 MG. CAJA 30 COMP. 131 6 5589087 1/2/2008 7,800,018,121,918 9,200

ARATAN 50 MG. CAJA 30 COMP. 131 7 5589093 1/3/2008 7,800,018,121,918 11,990

ARATAN-D CAJA 30 COMP. 35 2 220285 1/2/2008 7,800,018,121,192 10,760

ARATAN-D CAJA 30 COMP. 45 2 226178 1/3/2008 7,800,018,121,192 12,990

TAREG D 160/25 CAJA 28 COMP. 1 2 5014087 1/3/2008 7,800,032,002,019 11,860

TAREG D 160/25 CAJA 28 COMP. 1 7 225668 1/4/2008 7,800,032,002,019 15,490

FINDALER 10 MG. CAJA 30 COMP. 8 6 485252 1/8/2008 7,800,050,306,564 5,140

FINDALER 10 MG. CAJA 30 COMP. 8 4 291086 1/9/2008 7,800,050,306,564 6,700

CLARIMAX 500 MG. CAJA 14 COMP. 202 8 671 1/9/2008 7,800,018,150,741 11,790

CLARIMAX 500 MG. CAJA 14 COMP. 213 6 304028 1/10/2008 7,800,018,150,741 13,600

LEXAPRO 10 MG. CAJA 28 COMP. 2 3 196911 2/19/2008 7,798,092,890,137 14,390

LEXAPRO 10 MG. CAJA 28 COMP. 2 4 231938 2/20/2008 7,798,092,890,137 18,900

HEROLAN AEROSOL 10 ML 200 DOSIS 92 3 598717 3/12/2008 7,800,007,112,316 5,600

HEROLAN AEROSOL 10 ML 200 DOSIS 92 2 514136 3/13/2008 7,800,007,112,316 6,500

TRITTICO 100 MG X 20 COMP. 55 1 95217 3/12/2008 7,800,007,100,146 8,200

TRITTICO 100 MG X 20 COMP. 55 1 4738468 3/13/2008 7,800,007,100,146 10,500

POSIVYL 20MG X 30COMP. 26 3 374449 3/12/2008 7,800,007,431,172 14,500

POSIVYL 20MG X 30COMP. 26 2 11571 3/13/2008 7,800,007,431,172 16,900

IMECOL CAJA 20 COMP. AD. 14 3 222510 4/1/2008 7,800,026,020,357 2,690

IMECOL CAJA 20 COMP. AD. 14 3 222773 4/2/2008 7,800,026,020,357 4,260

Page 27: tablas de sql ejemplos sensillos

Página 27 de 31

TABLA 22

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

CIPRAMIL 20 MG. CAJA 28 COMP. 1 5 249927 4/1/2008 7,800,020,037,610 16,900

CIPRAMIL 20 MG. CAJA 28 COMP. 1 5 250038 4/2/2008 7,800,020,037,610 22,000

VENASTAT 290 MG. CAJA 30 CAP. 15 6 254068 25/12/2007 7809599500044 6,120

VENASTAT 290 MG. CAJA 30 CAP. 45 3 227694 26/12/2007 7809599500044 7,990

NEO SINTROM 4 MG. CAJA 20 COMP. 5 7 5588341 1/1/2008 7,800,032,000,411 7,950

NEO SINTROM 4 MG. CAJA 20 COMP. 5 6 657590 1/2/2008 7,800,032,000,411 10,175

ERANZ 10 MG. CAJA 28 COMP. 232 4 119933 20/01/2008 7800033080832 69,890

ERANZ 10 MG. CAJA 28 COMP.Obs: Eranz sin venta 21/01/2008

CONFER CAJA 30 CAP. 13 8 68184 1/29/2008 7,800,017,065,435 3,490CONFER CAJA 30 CAP. 13 10 112791 39477 7800017065435 5,060

ARAVA 20 MG. CAJA 30 COMP. 81 2 510091 3/5/2008 7,795,315,000,663 33,370ARAVA 20 MG. CAJA 30 COMP. 145 8 5945588 39513 7795315000663 46,990

ISKIMIL 75 MG. CAJA 30 COMP. REC. 3 4 185599 3/5/2008 7,800,097,000,890 14,750ISKIMIL 75 MG. CAJA 30 COMP. REC. 15 4 524260 39513 7800097000890 18,200

GYNOSTAT 20 21C 240 8 472302 11/03/2008 7800007422422 4,700GYNOSTAT 20 21C 300 4 72986 12/03/2008 7800007422422 5,500

GRIFOPARKIN X 30 COMP. 5 7 46330 11/03/2008 7800007103406 8,500GRIFOPARKIN X 30 COMP. 240 9 46164 12/03/2008 7800007103406 9,500

DORSOF T COL. FCO. 5ML 2 1 222303 11/03/2008 7800007559807 11,900DORSOF T COL. FCO. 5ML 202 12 131820 12/03/2008 7800007559807 13,200

LIFTER 50 MG. CAJA 5 COMP. 8 4 301904 3/12/2008 7,800,060,111,851 6,420LIFTER 50 MG. CAJA 5 COMP. 8 6 496086 39520 7800060111851 9,890

EBIXA 10 MG. CAJA 56 COMP. REC. 8 1 307212 3/17/2008 7,798,092,890,182 32,900EBIXA 10 MG. CAJA 56 COMP. REC. 8 1 307494 39525 7798092890182 40,900

ANULETTE-CD CAJA 28 COMP. 1 7 233670 3/31/2008 7,800,020,038,617 1,830ANULETTE-CD CAJA 28 COMP. 1 5 249952 39539 7800020038617 2,900

SIMPERTEN D 100 MG CAJA 30 COMP. 8 6 495855 3/12/2008 7,800,007,629,449 8,500SIMPERTEN D 100 MG CAJA 30 COMP. 8 2 135419 39520 7800007629449 9,800

LADY-TEN X 21 COMP REC UF 14 3 220625 3/12/2008 7,800,007,477,910 6,800LADY-TEN X 21 COMP REC UF 14 1 67023 39520 7800007477910 8,900

SULPILAN 50 MG. CAJA 30 CAP. 5 7 44145 3/3/2008 7,804,907,010,901 5,340SULPILAN 50 MG. CAJA 30 CAP. 5 6 680611 39511 7804907010901 6,700

Page 28: tablas de sql ejemplos sensillos

Página 28 de 31

TABLA 23

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

TALFLEX 100 MG. CAJA 20 COMP. 2 2 214308 12/10/2007 7,800,028,000,609 4,600

TALFLEX 100 MG. CAJA 20 COMP. 2 1 219933 12/11/2007 7,800,028,000,609 6,500

NEURYL 2 MG. CAJA 30 COMP 1 7 223557 12/10/2007 7,800,028,000,104 4,840

NEURYL 2 MG. CAJA 30 COMP 1 7 223599 12/11/2007 7,800,028,000,104 5,500

DINAFLEX DUO FORTE CAJA 30 SOBR. 3 1 10694 12/11/2007 7,800,070,004,556 14,980

DINAFLEX DUO FORTE CAJA 30 SOBR. 3 6 35941 12/12/2007 7,800,070,004,556 18,990

DINAFLEX DUO CAJA 60 CAP. 1 5 240497 12/11/2007 7,800,070,004,341 9,270

DINAFLEX DUO CAJA 60 CAP. 1 3 2327 12/12/2007 7,800,070,004,341 11,990

CRONUS CAJA 20 COMP. 1 2 173526 12/11/2007 7,800,070,000,541 7,370

CRONUS CAJA 20 COMP. 1 3 2282 12/12/2007 7,800,070,000,541 8,990

DINAFLEX DUO CAJA 40 CAP. 2 4 223202 12/11/2007 7,800,070,004,334 9,050

DINAFLEX DUO CAJA 40 CAP. 16 6 177830 12/12/2007 7,800,070,004,334 10,890

AERO-ITAN CAJA 20 CAP. 11 10 142474 12/16/2007 7,800,060,003,651 2,200

AERO-ITAN CAJA 20 CAP. 11 4 60470 12/17/2007 7,800,060,003,651 3,790

MICARDIS PLUS 80/12,5 MG.CAJA 28 COMP. 70 5 476174 12/25/2007 7,795,304,866,539 8,270

MICARDIS PLUS 80/12,5 MG.CAJA 28 COMP. 72 6 214051 12/26/2007 7,795,304,866,539 10,990

SPIRIVA 18 MCG. CAJA 30 CAP. 5 5 5588210 12/25/2007 7,809,599,500,143 21,590

SPIRIVA 18 MCG. CAJA 30 CAP. 11 7 218001 12/26/2007 7,809,599,500,143 28,070

MICARDIS 80 MG. CAJA 28 COMP. 84 3 229843 12/25/2007 7,795,304,866,065 9,740

MICARDIS 80 MG. CAJA 28 COMP. 86 4 112448 12/26/2007 7,795,304,866,065 11,990

COMBIVENT INH. BUC. 200 DOSIS 22 4 47003 12/25/2007 7,795,304,866,430 3,830

COMBIVENT INH. BUC. 200 DOSIS 26 4 502728 12/26/2007 7,795,304,866,430 5,990

INFLAMMIDE 200 MCG INH. BUC/NAS 300DOSIS 5 8 278233 12/25/2007 7,795,304,866,874 6,650

INFLAMMIDE 200 MCG INH. BUC/NAS 300DOSIS 5 8 278344 12/26/2007 7,795,304,866,874 9,950

MOBEX 15 MG. CAJA 10 COMP. 37 6 25367 12/25/2007 7,795,304,000,476 4,550

MOBEX 15 MG. CAJA 10 COMP. 37 1 337021 12/26/2007 7,795,304,000,476 5,460

BERODUAL SOL. FCO. 20 ML. 81 2 496326 12/25/2007 7,896,026,304,993 8,270

BERODUAL SOL. FCO. 20 ML. 99 3 189787 12/26/2007 7,896,026,304,993 9,920

DINAFLEX DUO FORTE CAJA 30 SOBR. 26 4 502629 12/26/2007 7,800,070,004,556 18,610

DINAFLEX DUO FORTE CAJA 30 SOBR. 26 2 6945 12/27/2007 7,800,070,004,556 24,750

DINAFLEX DUO CAJA 60 CAP. 8 1 295923 12/26/2007 7,800,070,004,341 11,750

DINAFLEX DUO CAJA 60 CAP. 8 1 296069 12/27/2007 7,800,070,004,341 14,490

COSOPT COL. FCO. 5 ML. 8 4 295975 2/6/2008 3,556,610,000,246 13,490

COSOPT COL. FCO. 5 ML. 8 4 296022 2/7/2008 3,556,610,000,246 14,840

DAGOTIL 1MG/ML. SOL. FCO. 30 ML. 70 2 498902 10/03/2008 7800097980444 10,880

DAGOTIL 1MG/ML. SOL. FCO. 30 ML. 240 7 64729 11/03/2008 7800097980444 12,990

LUVOX 100 MG CAJA 15 COMP. 360 2 54636 10/03/2008 7800097000968 14,890

Page 29: tablas de sql ejemplos sensillos

Página 29 de 31

TABLA 23

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

LUVOX 100 MG CAJA 15 COMP. 235 4 386338 11/03/2008 7800097000968 18,990

Page 30: tablas de sql ejemplos sensillos

Página 30 de 31

TABLA 23

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

DAGOTIL 3 MG. CAJA 30 COMP. 26 2 11271 10/03/2008 7800097000425 13,500

DAGOTIL 3 MG. CAJA 30 COMP. 81 4 380257 11/03/2008 7800097000425 14,990

CARBORON RETARD 400 MG. CAJA 30 COMP. 8 2 135141 10/03/2008 7800097980451 7,730

CARBORON RETARD 400 MG. CAJA 30 COMP. 2 5 213312 11/03/2008 7800097980451 10,590

ISKIMIL 75 MG. CAJA 30 COMP. REC. 13 7 381861 3/10/2008 7,800,097,000,890 18,200

ISKIMIL 75 MG. CAJA 30 COMP. REC. 13 4 27536 3/11/2008 7,800,097,000,890 20,200

DEPUROL RETARD 75 MG. CAJA 30 CAP. 283 4 222558 3/10/2008 7,800,097,000,449 16,500

DEPUROL RETARD 75 MG. CAJA 30 CAP. 378 1 64092 3/11/2008 7,800,097,000,449 19,490

ZYPREXA ZYDIS 10 MG. 7 COMP. 267 4 235942 10/03/2008 7795990001535 28,510

ZYPREXA ZYDIS 10 MG. 7 COMP. 81 2 511058 3/11/2008 7,795,990,001,535 30,990

EFEXOR XR 37.5 MG. CAJA 30 CAP. 2 2 225994 3/10/2008 7,800,033,080,986 26,280

EFEXOR XR 37.5 MG. CAJA 30 CAP. 2 5 213280 3/11/2008 7,800,033,080,986 28,990

EUTIROX 125 MCG. CAJA 50 COMP. 1 7 231869 3/10/2008 7,800,017,061,253 3,600

EUTIROX 125 MCG. CAJA 50 COMP. 1 5 248207 3/11/2008 4,022,536,980,744 5,190

GLUCOPHAGE FORTE 850 MG. CAJA 60 COMP. 5 8 290287 3/10/2008 7,800,010,040,125 6,990

GLUCOPHAGE FORTE 850 MG. CAJA 60 COMP. 5 6 5491750 3/11/2008 7,800,010,040,125 9,990

GLUCOPHAGE FORTE 850 MG. CAJA 30 COMP 162 3 5975268 3/10/2008 7,800,010,040,101 4,690

GLUCOPHAGE FORTE 850 MG. CAJA 30 COMP 162 2 142559 3/11/2008 7,800,010,040,101 6,990

LOMEX 20 MG. CAJA FCO. 35 CAP. 21 3 115594 3/12/2008 7,800,060,117,211 13,400

LOMEX 20 MG. CAJA FCO. 35 CAP. 21 3 115949 3/13/2008 7,800,060,117,211 16,990

ENALTEN-D 10/25 CAJA 30 COMP. 5 7 49707 25/03/2008 7800060405684 6,900

ENALTEN-D 10/25 CAJA 30 COMP. 5 5 609820 26/03/2008 7800060405684 8,690

HIDRIUM CAJA 20 COMP. 9 3 383612 3/25/2008 7,800,060,009,912 3,400

HIDRIUM CAJA 20 COMP. 10 3 225618 3/26/2008 7,800,060,009,912 4,390

ENALTEN 5 MG. CAJA 30 COMP. 15 4 528117 3/25/2008 7,800,060,405,332 4,910

ENALTEN 5 MG. CAJA 30 COMP. 15 6 256669 3/26/2008 7,800,060,405,332 6,990

GRIFOPARKIN X 30 COMP. 240 7 67019 25/03/2008 7800007103406 8,920

GRIFOPARKIN X 30 COMP. 202 8 1022 26/03/2008 7800007103406 10,200

DORSOF T COL. FCO. 5ML 202 12 133965 25/03/2008 7800007559807 13,200

DORSOF T COL. FCO. 5ML 69 2 315589 26/03/2008 7800007559807 15,400

AERO-ITAN CAJA 20 CAP. 5 6 688520 3/25/2008 7,800,060,003,651 3,790

AERO-ITAN CAJA 20 CAP. 5 7 50071 3/26/2008 7,800,060,003,651 4,590

CORTIPREX 20 MG X 20 COMP. 1 6 172369 3/25/2008 7,800,007,313,645 4,900

CORTIPREX 20 MG X 20 COMP. 1 5 249381 3/26/2008 7,800,007,313,645 5,700

DACAM RL X 1 FCO.AMP. 26 4 516061 3/25/2008 7,800,007,339,799 10,900

DACAM RL X 1 FCO.AMP. 26 3 375974 3/26/2008 7,800,007,339,799 12,650

Page 31: tablas de sql ejemplos sensillos

Página 31 de 31

TABLA 23

Descriptor Local Caja NroBoleta Fecha CodBarra PVP FASA

SIMPERTEN 50 MG X 30 COMP. 58 2 317396 26/03/2008 7800007383266 9,800

SIMPERTEN 50 MG X 30 COMP. 202 9 277332 27/03/2008 7800007383266 10,900

LADY-TEN X 21 COMP REC 240 8 475446 26/03/2008 7800007477910 8,900

LADY-TEN X 21 COMP REC 5 8 293875 27/03/2008 7800007477910 10,070

GYNOSTAT 20 21C 5 6 689143 26/03/2008 7800007422422 5,500

GYNOSTAT 20 21C 8 6 498545 27/03/2008 7800007422422 6,500

SIMPERTEN D 100 MG CAJA 30 COMP. 69 3 234529 26/03/2008 7800007629449 9,800

SIMPERTEN D 100 MG CAJA 30 COMP. 202 9 277332 27/03/2008 7800007629449 10,900

POSIVYL 20MG X 30COMP. 15 4 528291 3/26/2008 7,800,007,431,172 16,900

POSIVYL 20MG X 30COMP. 19 3 140064 3/27/2008 7,800,007,431,172 18,500

TRITTICO 100 MG X 20 COMP. 33 1 163356 3/26/2008 7,800,007,100,146 10,500

TRITTICO 100 MG X 20 COMP. 33 6 29767 3/27/2008 7,800,007,100,146 12,200

ELCAL 320 MG. CAJA 60 CAP. 17 4 14894 12/3/2007 7,800,018,126,630 5,750

ELCAL 320 MG. CAJA 60 CAP. 20 2 23437 12/4/2007 7,800,018,126,630 7,260

ELCAL 320 MG. CAJA 30 CAP. 125 2 30525 12/3/2007 7,800,034,514,022 3,840

ELCAL 320 MG. CAJA 30 CAP. 125 3 35692 12/4/2007 7,800,034,514,022 4,850

PROGYLUTON CAJA 21 GRAG. 144 8 222338 1/2/2008 7,703,331,106,900 14,410

PROGYLUTON CAJA 21 GRAG. 351 3 44938 1/3/2008 7,703,331,106,900 15,860

MINULET CAJA 21 GRAG. 202 7 63605 2/6/2008 7,800,033,030,332 9,690

MINULET CAJA 21 GRAG. 202 12 127881 2/7/2008 7,792,499,450,109 10,680

PROGYLUTON CAJA 21 GRAG. 8 5 259700 22/02/2008 7703331106900 15,860

PROGYLUTON CAJA 21 GRAG. 470 4 6194 23/02/2008 7703331106900 16,660

FLEMEX J.A.T. JBE. FCO.120 ML. 3 4 186386 3/19/2008 7,800,026,025,505 5,590

FLEMEX J.A.T. JBE. FCO.120 ML. 3 6 44686 3/20/2008 7,800,026,025,505 8,300

TOBE 2,5 MG X 30 COMP. 84 3 239242 26/03/2008 7800007629289 10,500

TOBE 2,5 MG X 30 COMP. 5 5 609983 27/03/2008 7800007629289 12,400

RINOVEN CAJA 28 COMP. 64 5 230049 4/8/2008 7,800,050,302,702 7,220

RINOVEN CAJA 28 COMP. 69 1 80146 4/9/2008 7,800,050,302,702 8,240

NUMOSOL 50MG/5ML. JBE. 100 ML. 292 4 194645 4/8/2008 7,800,050,009,656 3,160

NUMOSOL 50MG/5ML. JBE. 100 ML. 292 4 194785 4/9/2008 7,800,050,009,656 3,610

DOLOFAR T.U. 200 MG. CAJA 10 COMP. 47 3 227135 4/8/2008 7,800,050,306,540 4,750

DOLOFAR T.U. 200 MG. CAJA 10 COMP. 64 6 19569 4/9/2008 7,800,050,306,540 5,320

ANULETTE-CD CAJA 28 COMP. 5 7 45214 3/7/2008 7,800,020,038,617 1,250

ANULETTE-CD CAJA 28 COMP. 5 5 604039 3/8/2008 7,800,020,038,617 1,990