000

http://www.yourhtmlsource.com/accessibility/mobile.html/

sum luongung va công cong doan

SELECT CCD.min_ngayCong, congNhanTbl.maCN, congNhanTbl.hoCN, congNhanTbl.tenCN, CCD.soLuongBSPOFSUM, 
             LU.soLuongUng, LU.mucLuongTra,
              LU.thuong, LU.thuNhapKhac, LU.tienCom, LU.tienKim,  
              LU.tienTru, LU.tangCa
FROM (SELECT MIN(Format (congCongDoanTbl.ngayCong, "yyyy/mm")) As min_ngayCong, congCongDoanTbl.maCN AS maCN, SUM(congCongDoanTbl.soLuongBSP) AS soLuongBSPOFSUM
             FROM congCongDoanTbl WHERE congCongDoanTbl.ngayCong >= #2/1/2012# AND congCongDoanTbl.ngayCong < #3/1/2012#
             GROUP BY congCongDoanTbl.maCN) AS CCD,
             (SELECT MIN(luongUngTbl.thangUng), luongUngTbl.maCN AS maCN,   SUM(luongUngTbl.soLuongUng) AS soLuongUng, SUM(luongUngTbl.mucLuongTra) AS mucLuongTra,
              SUM(luongUngTbl.thuong) AS thuong, SUM(luongUngTbl.thuNhapKhac) AS thuNhapKhac, SUM(luongUngTbl.tienCom) AS tienCom, SUM(luongUngTbl.tienKim) AS tienKim,  
              SUM(luongUngTbl.tienTru) AS tienTru, SUM(luongUngTbl.tangCa) AS tangCa
             FROM luongUngTbl WHERE luongUngTbl.thangUng >=  #2/1/2012# AND luongUngTbl.thangUng <  #3/1/2012#
             GROUP BY luongUngTbl.maCN) AS LU,
             congNhanTbl
WHERE congNhanTbl.maCN = CCD.maCN AND CCD.maCN = LU.maCN
ORDER BY congNhanTbl.maCN



-------------
luong ung
SELECT luongUngTbl.thangUng, luongUngTbl.maCN AS luongUngTbl_maCN, luongUngTbl.soLuongUng, luongUngTbl.soNgayCong, luongUngTbl.mucLuongTra, luongUngTbl.thuong, luongUngTbl.thuNhapKhac, luongUngTbl.tienCom, luongUngTbl.tienKim, luongUngTbl.tienTru, luongUngTbl.tangCa
FROM luongUngTbl
WHERE luongUngTbl.thangUng >= #2/1/2012# AND luongUngTbl.thangUng < #3/1/2012#
ORDER BY luongUngTbl.maCN;


---------
list product
SELECT MIN(congCongDoanTbl.ngayCong) As min_ngayCong, congCongDoanTbl.maCN AS congCongDoanTbl_maCN, congCongDoanTbl.maSanPham, congCongDoanTbl.maCD, SUM(congCongDoanTbl.soLuongBSP) AS soLuongBSPofSum, congDoanTbl.donGiaCD
FROM congCongDoanTbl, congDoanTbl
WHERE congCongDoanTbl.ngayCong >= #2/1/2012# AND congCongDoanTbl.ngayCong < #3/1/2012#
              AND congCongDoanTbl.maSanPham = congDoanTbl.maSanPham
              AND congCongDoanTbl.maCD = congDoanTbl.maCD
GROUP BY congCongDoanTbl.maCN, congCongDoanTbl.maSanPham, congCongDoanTbl.maCD, congDoanTbl.donGiaCD
ORDER BY MIN(congCongDoanTbl.ngayCong), congCongDoanTbl.maCN, congCongDoanTbl.maSanPham, congCongDoanTbl.maCD, congDoanTbl.donGiaCD;



-----
list luong ung  va CD
SELECT CCD.min_ngayCong, congNhanTbl.maCN, congNhanTbl.hoCN, congNhanTbl.tenCN, CCD.soLuongBSPOFSUM, 
             LU.soLuongUng, LU.mucLuongTra,
              LU.thuong, LU.thuNhapKhac, LU.tienCom, LU.tienKim,  
              LU.tienTru, LU.tangCa
FROM (SELECT MIN(Format (congCongDoanTbl.ngayCong, "yyyy/mm")) As min_ngayCong, congCongDoanTbl.maCN AS maCN, SUM(congCongDoanTbl.soLuongBSP) AS soLuongBSPOFSUM
             FROM congCongDoanTbl WHERE congCongDoanTbl.ngayCong >= #2/1/2012# AND congCongDoanTbl.ngayCong < #3/1/2012#
             GROUP BY congCongDoanTbl.maCN) AS CCD,
             (SELECT MIN(luongUngTbl.thangUng), luongUngTbl.maCN AS maCN,   SUM(luongUngTbl.soLuongUng) AS soLuongUng, SUM(luongUngTbl.mucLuongTra) AS mucLuongTra,
              SUM(luongUngTbl.thuong) AS thuong, SUM(luongUngTbl.thuNhapKhac) AS thuNhapKhac, SUM(luongUngTbl.tienCom) AS tienCom, SUM(luongUngTbl.tienKim) AS tienKim,  
              SUM(luongUngTbl.tienTru) AS tienTru, SUM(luongUngTbl.tangCa) AS tangCa
             FROM luongUngTbl WHERE luongUngTbl.thangUng >=  #2/1/2012# AND luongUngTbl.thangUng <  #3/1/2012#
             GROUP BY luongUngTbl.maCN) AS LU,
             congNhanTbl
WHERE congNhanTbl.maCN = CCD.maCN AND CCD.maCN = LU.maCN
ORDER BY congNhanTbl.maCN

"'Abyssos'","'ABYSSOS'"
"Accesnted","ACCESNTED"
"'Activator'","'ACTIVATOR'"
"Adonis","ADONIS"
"Agate","AGATE"
"Aggies","AGGIES"
"Akribos","AKRIBOS"
"Alabama","ALABAMA"
"Allessandra","ALLESSANDRA"
"Amazonite","AMAZONITE"
"Ambulance","AMBULANCE"
"'Amerigo'","'AMERIGO'"
"Amy","AMY"
"'Amy'","'AMY'"
"Android","ANDROID"
"'Ansel'","'ANSEL'"
"Antiforce","ANTIFORCE"
"'Antiforce'","'ANTIFORCE'"
"Apocalypse","APOCALYPSE"
"'Aquamatic'","'AQUAMATIC'"
"'Aquis","'AQUIS"
"'Arabasque","'ARABASQUE"
"Arabic","ARABIC"
"Arbelos","ARBELOS"
"Architect","ARCHITECT"
"Are","ARE"
"Aristocrat","ARISTOCRAT"
"'Aristocrat'","'ARISTOCRAT'"
"Armata","ARMATA"
"Artemis","ARTEMIS"
"'Artemis'","'ARTEMIS'"
"Astor","ASTOR"
"Attendant","ATTENDANT"
"Audrey","AUDREY"
"'Audrey'","'AUDREY'"
"August","AUGUST"
"Augustus","AUGUSTUS"
"Austrian","AUSTRIAN"
"Autometer","AUTOMETER"
"Autoquartz","AUTOQUARTZ"
"'Avance'","'AVANCE'"
"'Avation'","'AVATION'"
"Azria","AZRIA"
"Azzaro","AZZARO"
"Azzaro'","AZZARO'"
"Bahama","BAHAMA"
"Baily","BAILY"
"'Basel'","'BASEL'"
"Basilica","BASILICA"
"Basketweave","BASKETWEAVE"
"'Baton'","'BATON'"
"Baylor","BAYLOR"
"Beadwork","BEADWORK"
"'Belmont'","'BELMONT'"
"Bengals","BENGALS"
"Bernard","BERNARD"
"Bertelin","BERTELIN"
"Bianci","BIANCI"
"Bicentennial","BICENTENNIAL"
"Biltmore","BILTMORE"
"Blacktone","BLACKTONE"
"Blass","BLASS"
"Blink","BLINK"
"'Bonaventura'","'BONAVENTURA'"
"Bonghino","BONGHINO"
"Botanica","BOTANICA"
"'Boundary'","'BOUNDARY'"
"Boxes","BOXES"
"Boxy","BOXY"
"Bracer","BRACER"
"'Bracer'","'BRACER'"
"Bradshaw","BRADSHAW"
"'Bradshaw'","'BRADSHAW'"
"Brands","BRANDS"
"'Bridgeport'","'BRIDGEPORT'"
"Brigade","BRIGADE"
"Brilliance","BRILLIANCE"
"Britto","BRITTO"
"Britto'","BRITTO'"
"Broken","BROKEN"
"Broncos","BRONCOS"
"Buceador","BUCEADOR"
"Bucherer","BUCHERER"
"Bulldogs","BULLDOGS"
"Burgi","BURGI"
"Burlwood","BURLWOOD"
"Butterflies","BUTTERFLIES"
"'Cabo'","'CABO'"
"Caicos","CAICOS"
"'CaptainElite'","'CAPTAINELITE'"
"'Captiva'","'CAPTIVA'"
"Caravelle","CARAVELLE"
"'Caravelle'","'CARAVELLE'"
"Cardini","CARDINI"
"Carlyle","CARLYLE"
"Cassic","CASSIC"
"Cautiva","CAUTIVA"
"Cavatina","CAVATINA"
"'Celano'","'CELANO'"
"'CeramicSlim'","'CERAMICSLIM'"
"Cerny","CERNY"
"Cerruti","CERRUTI"
"Cervin","CERVIN"
"'Cervin'","'CERVIN'"
"'Challenge-R","'CHALLENGE-R"
"Chantility","CHANTILITY"
"'Charing","'CHARING"
"Charriol","CHARRIOL"
"Chateau","CHATEAU"
"Checkered","CHECKERED"
"Cheetah","CHEETAH"
"Chernabog","CHERNABOG"
"Cherrywood","CHERRYWOOD"
"Chevalier","CHEVALIER"
"Chicago","CHICAGO"
"Chonograph","CHONOGRAPH"
"'Chopin'","'CHOPIN'"
"Chorma'","CHORMA'"
"Chorno'","CHORNO'"
"Chorongraph","CHORONGRAPH"
"Chrongraph","CHRONGRAPH"
"'Chronofighter'","'CHRONOFIGHTER'"
"'Chronomaster","'CHRONOMASTER"
"Chronomaster'","CHRONOMASTER'"
"'Chronomaster'","'CHRONOMASTER'"
"Chrononograph","CHRONONOGRAPH"
"Cid'","CID'"
"Cincinnati","CINCINNATI"
"Circlo","CIRCLO"
"'Clasic'","'CLASIC'"
"Classica","CLASSICA"
"'Classica'","'CLASSICA'"
"Classiques","CLASSIQUES"
"Classiques'","CLASSIQUES'"
"Classy","CLASSY"
"Claus","CLAUS"
"Clerc","CLERC"
"Collectors","COLLECTORS"
"Colorful","COLORFUL"
"Colosso","COLOSSO"
"'Colosso'","'COLOSSO'"
"Competencia","COMPETENCIA"
"Complex'","COMPLEX'"
"'Compressor2'","'COMPRESSOR2'"
"Concorso","CONCORSO"
"'Concorso'","'CONCORSO'"
"Condezza","CONDEZZA"
"'Condezza","'CONDEZZA"
"'Condezza'","'CONDEZZA'"
"'Connoisseur'","'CONNOISSEUR'"
"'Conqueror'","'CONQUEROR'"
"'Continual'","'CONTINUAL'"
"Convex","CONVEX"
"Cookie","COOKIE"
"Coppertone","COPPERTONE"
"Corale","CORALE"
"Coronis","CORONIS"
"'Corvara'","'CORVARA'"
"Cosi","COSI"
"'Cosmopolitan'","'COSMOPOLITAN'"
"Cottage","COTTAGE"
"Courtly","COURTLY"
"Crab","CRAB"
"Crossbones","CROSSBONES"
"Crucial","CRUCIAL"
"Crystale","CRYSTALE"
"ct","CT"
"ctw","CTW"
"Cuadrados","CUADRADOS"
"'Cuadro'","'CUADRO'"
"Cuadrods","CUADRODS"
"'Cuadrods'","'CUADRODS'"
"'Cubanito'","'CUBANITO'"
"Cubic","CUBIC"
"Cupid","CUPID"
"'Curacao'","'CURACAO'"
"Cure'","CURE'"
"'Cuvette'","'CUVETTE'"
"Cvstos","CVSTOS"
"Czech","CZECH"
"CZ-lined","CZ-LINED"
"Dalphine","DALPHINE"
"Daniel","DANIEL"
"Daphne","DAPHNE"
"'Daredevil'","'DAREDEVIL'"
"Darvesi","DARVESI"
"Datejust","DATEJUST"
"'Datejust'","'DATEJUST'"
"Dazzle","DAZZLE"
"Deauville","DEAUVILLE"
"Decorative","DECORATIVE"
"Decoy","DECOY"
"'Decoy'","'DECOY'"
"Defy","DEFY"
"Delos","DELOS"
"Dentist","DENTIST"
"Denver","DENVER"
"Deployment","DEPLOYMENT"
"DesignsSiilver","DESIGNSSIILVER"
"Dessert","DESSERT"
"Detailed","DETAILED"
"dies","DIES"
"Dimamica","DIMAMICA"
"Dinamica","DINAMICA"
"Dinamica'","DINAMICA'"
"Divemaster","DIVEMASTER"
"Dolphins","DOLPHINS"
"Domination","DOMINATION"
"Dong'","DONG'"
"Doors","DOORS"
"Dorian","DORIAN"
"Doube","DOUBE"
"Dragonflies","DRAGONFLIES"
"Duchess'","DUCHESS'"
"Dufonte","DUFONTE"
"Dunn","DUNN"

"Earnhardt","EARNHARDT"
"Eastender","EASTENDER"
"'Eastender","'EASTENDER"
"Easter","EASTER"
"'Editions/500","'EDITIONS/500"
"'Editions/600","'EDITIONS/600"
"'Editions/700","'EDITIONS/700"
"Effortless","EFFORTLESS"
"Efron","EFRON"
"Elephant","ELEPHANT"
"Elevated","ELEVATED"
"Elixer","ELIXER"
"Elongated","ELONGATED"
"Emporio","EMPORIO"
"Engrave'","ENGRAVE'"
"Ensemble","ENSEMBLE"
"'Entrepreneur'","'ENTREPRENEUR'"
"Eograph","EOGRAPH"
"'Eograph'","'EOGRAPH'"
"'Eraganto","'ERAGANTO"
"Esso","ESSO"
"Estate'","ESTATE'"
"Eternal","ETERNAL"
"European","EUROPEAN"
"Euxine","EUXINE"
"Euxine-2","EUXINE-2"
"Everest","EVEREST"
"Everlasting","EVERLASTING"
"Ewatch","EWATCH"
"Exhibiton","EXHIBITON"
"Eyelet","EYELET"
"Fairy","FAIRY"
"Faith","FAITH"
"'Felice'","'FELICE'"
"Fere","FERE"
"Ferre","FERRE"
"'Fiaba'","'FIABA'"
"Fidelity'","FIDELITY'"
"Fiego","FIEGO"
"File","FILE"
"Filigree","FILIGREE"
"Filligree","FILLIGREE"
"Filmore","FILMORE"
"'Filmore'","'FILMORE'"
"Flags","FLAGS"
"Flaming","FLAMING"
"Flamingo","FLAMINGO"
"Flieger","FLIEGER"
"Flier","FLIER"
"Flier'","FLIER'"
"Flik-flack","FLIK-FLACK"
"Florida","FLORIDA"
"Fob","FOB"
"Folie'","FOLIE'"
"Forces'","FORCES'"
"Fortis","FORTIS"
"Fortuner","FORTUNER"
"'Fractal'","'FRACTAL'"
"Frederique","FREDERIQUE"
"Frosty","FROSTY"
"Fulton","FULTON"
"Fuschia","FUSCHIA"
"Fushcia","FUSHCIA"
"Fushia","FUSHIA"
"'Gala'","'GALA'"
"'Galassia'","'GALASSIA'"
"Gallery","GALLERY"
"Gators","GATORS"
"Gatsby","GATSBY"
"'Gatsby","'GATSBY"
"Gaudens","GAUDENS"
"'Generosi'","'GENEROSI'"
"'GenerosiT'","'GENEROSIT'"
"Genta","GENTA"
"Gen-X","GEN-X"
"Gen-Y","GEN-Y"
"Germany","GERMANY"
"Glasstop","GLASSTOP"
"'Globetrotter'","'GLOBETROTTER'"
"'Gmt","'GMT"
"'Godat'","'GODAT'"
"Godltone","GODLTONE"
"Golana","GOLANA"
"Goldstone","GOLDSTONE"
"Goldtoned","GOLDTONED"
"Gorgeous","GORGEOUS"
"'Gorgeous","'GORGEOUS"
"Graham","GRAHAM"
"'GrammyEdition'","'GRAMMYEDITION'"
"'Greneda'","'GRENEDA'"
"Groomer","GROOMER"
"Groovy","GROOVY"
"Grouch","GROUCH"
"Grovana","GROVANA"
"Grover","GROVER"
"'Gulfstream'","'GULFSTREAM'"
"Halloween","HALLOWEEN"
"Hammered","HAMMERED"
"Hampden","HAMPDEN"
"Handicrafts","HANDICRAFTS"
"Harbour'","HARBOUR'"
"'Harvard","'HARVARD"
"Harvey","HARVEY"
"Hatteras","HATTERAS"
"Havana","HAVANA"
"'Haverford'","'HAVERFORD'"
"'Healey","'HEALEY"
"'Healey'","'HEALEY'"
"Hector","HECTOR"
"Heiden","HEIDEN"
"Henry","HENRY"
"'Henry'","'HENRY'"
"Heuer","HEUER"
"'Hevea'","'HEVEA'"
"Heys","HEYS"
"'Highlight'","'HIGHLIGHT'"
"Highlights","HIGHLIGHTS"
"Hills","HILLS"
"Hilton","HILTON"
"Hinge","HINGE"
"Horitzon","HORITZON"
"Houston","HOUSTON"
"Hummingbirds","HUMMINGBIRDS"
"Huntsman","HUNTSMAN"
"Huskers","HUSKERS"
"'Hyperion'","'HYPERION'"
"'Hypnotic'","'HYPNOTIC'"
"Hypo-Allergenic","HYPO-ALLERGENIC"
"Ickx'","ICKX'"
"Ii","II"
"'Imogene'","'IMOGENE'"
"'Impetus'","'IMPETUS'"
"Incanto","INCANTO"
"'Index","'INDEX"
"'Index'","'INDEX'"
"Indian","INDIAN"
"Initial","INITIAL"
"'Instrumentino","'INSTRUMENTINO"
"'Instrumento","'INSTRUMENTO"
"Interchangable","INTERCHANGABLE"
"Intercontinental","INTERCONTINENTAL"
"'Islander'","'ISLANDER'"
"Jacky","JACKY"
"Jambalaya","JAMBALAYA"
"Jasper","JASPER"
"Joaillerie'","JOAILLERIE'"
"JoJino","JOJINO"
"'JoJino'","'JOJINO'"
"'Jonesboro'","'JONESBORO'"
"Jorg","JORG"
"Joshua","JOSHUA"
"Jr.","JR."
"Julie","JULIE"
"July","JULY"
"June","JUNE"
"Juniors","JUNIORS"
"Juniors'","JUNIORS'"
"'Kalalis'","'KALALIS'"
"'Kali'","'KALI'"
"'Kandies","'KANDIES"
"Kansas","KANSAS"
"Karmica","KARMICA"
"Kenenth","KENENTH"
"Kidz","KIDZ"
"'Kingsbridge'","'KINGSBRIDGE'"
"Kor's","KOR'S"
"Kreisler","KREISLER"
"Lacquer","LACQUER"
"Lacriox","LACRIOX"
"Lacroix","LACROIX"
"'LadiesAutomatic'","'LADIESAUTOMATIC'"
"Ladybugs","LADYBUGS"
"Lapidus","LAPIDUS"
"Laureate","LAUREATE"
"Lavendar","LAVENDAR"
"Lawton","LAWTON"
"'Layers'","'LAYERS'"
"Lear","LEAR"
"Leatherette","LEATHERETTE"
"Lego","LEGO"
"Lemans","LEMANS"
"Leon","LEON"
"Libertad","LIBERTAD"
"Limeted","LIMETED"
"Lined","LINED"
"'Linque'","'LINQUE'"
"Lis","LIS"
"Lista","LISTA"
"Liter","LITER"
"Locman","LOCMAN"
"Longhorns","LONGHORNS"
"'Longwood'","'LONGWOOD'"
"Lover","LOVER"
"Lucien","LUCIEN"
"'Luminor","'LUMINOR"
"Lupah","LUPAH"
"'Lupah'","'LUPAH'"
"Macduff","MACDUFF"
"Maculate","MACULATE"
"'Magellano'","'MAGELLANO'"
"Magistrate","MAGISTRATE"
"Magnate","MAGNATE"
"Magnifier","MAGNIFIER"
"Magnifying","MAGNIFYING"
"Make","MAKE"
"'Make","'MAKE"
"Manchester","MANCHESTER"
"'Manchester","'MANCHESTER"
"Manhattan","MANHATTAN"
"Manifest","MANIFEST"
"'Mantis'","'MANTIS'"
"Manufacture","MANUFACTURE"
"Marcasite","MARCASITE"
"'MarineMaxi'","'MARINEMAXI'"
"Mariposa","MARIPOSA"
"Masella","MASELLA"
"'Masella'","'MASELLA'"
"Maurice","MAURICE"
"'Maxime","'MAXIME"
"'Maxime'","'MAXIME'"
"Metropolitan","METROPOLITAN"
"'Metropolitan'","'METROPOLITAN'"
"Microlight","MICROLIGHT"
"Millenia","MILLENIA"
"Millennia","MILLENNIA"
"'Millennia","'MILLENNIA"
"Milleret","MILLERET"
"Mirador","MIRADOR"
"'Mirador'","'MIRADOR'"
"Mirano","MIRANO"
"Misty'","MISTY'"
"mm","MM"
"Mom","MOM"
"Mondaine","MONDAINE"
"Montague","MONTAGUE"
"'Montague'","'MONTAGUE'"
"Monticello","MONTICELLO"
"Montres","MONTRES"
"Montserrat","MONTSERRAT"
"Monument","MONUMENT"
"'Moonchic'","'MOONCHIC'"
"Movida","MOVIDA"
"Mugler","MUGLER"
"Multicolor","MULTICOLOR"
"Musical","MUSICAL"
"Mykonos","MYKONOS"
"'Nabylia'","'NABYLIA'"
"Nardin","NARDIN"
"Narmi","NARMI"
"Natrual","NATRUAL"
"Nautico","NAUTICO"
"'Nautico'","'NAUTICO'"
"Nebraska","NEBRASKA"
"Nemeis","NEMEIS"
"Nevada","NEVADA"
"Newberry","NEWBERRY"
"Nightlife","NIGHTLIFE"
"'Ninja-50'","'NINJA-50'"
"Now","NOW"
"'Now","'NOW"
"Number","NUMBER"
"Numbers","NUMBERS"
"Nurse","NURSE"
"Nutcracker","NUTCRACKER"
"Obama","OBAMA"
"Oblong","OBLONG"
"Odaci-T","ODACI-T"
"Official","OFFICIAL"
"Officina","OFFICINA"
"Ole","OLE"
"Olympian","OLYMPIAN"
"Opener","OPENER"
"Openwork","OPENWORK"
"'Operetta'","'OPERETTA'"
"Orginal","ORGINAL"
"Orlogi","ORLOGI"
"Orpheum","ORPHEUM"
"Oscar","OSCAR"
"Oshi","OSHI"
"Ovalados","OVALADOS"
"Overlay","OVERLAY"
"Oyster","OYSTER"
"Oysterdate","OYSTERDATE"
"Ozzie","OZZIE"
"Ozzie'","OZZIE'"
"'Paladion'","'PALADION'"
"Palidoro","PALIDORO"
"Panerai","PANERAI"
"Panthere","PANTHERE"
"Paros","PAROS"
"'Paros'","'PAROS'"
"'Patravi'","'PATRAVI'"
"Patriarch","PATRIARCH"
"Patrician","PATRICIAN"
"'Pazione'","'PAZIONE'"
"Pc","PC"
"Peaugot","PEAUGOT"
"Pebbled","PEBBLED"
"Pedre","PEDRE"
"'Peking","'PEKING"
"Pelly","PELLY"
"Perdita","PERDITA"
"Persida","PERSIDA"
"'Persida","'PERSIDA"
"'Persida'","'PERSIDA'"
"'Persuasion","'PERSUASION"
"Peugeot","PEUGEOT"
"Peyote","PEYOTE"
"Pharmacy","PHARMACY"
"Piano","PIANO"
"'Pianosa'","'PIANOSA'"
"Piattino","PIATTINO"
"'Piattino","'PIATTINO"
"Piccard","PICCARD"
"Picture","PICTURE"
"pieces)","PIECES)"
"Plastceramic","PLASTCERAMIC"
"'Platnium'","'PLATNIUM'"
"Plerre","PLERRE"
"Plotos","PLOTOS"
"Pointium","POINTIUM"
"Policarbonate","POLICARBONATE"
"Polymer","POLYMER"
"'Portosera","'PORTOSERA"
"'Portosera'","'PORTOSERA'"
"Potpourri","POTPOURRI"
"Prayer","PRAYER"
"Prayer'","PRAYER'"
"'Precious'","'PRECIOUS'"
"Precisionist","PRECISIONIST"
"Pree","PREE"
"PreeSteel","PREESTEEL"
"Preschool","PRESCHOOL"
"President","PRESIDENT"
"'President'","'PRESIDENT'"
"Presidential","PRESIDENTIAL"
"presser","PRESSER"
"Prestigio","PRESTIGIO"
"Primero'","PRIMERO'"
"Princesses","PRINCESSES"
"Prints","PRINTS"
"'ProDiver","'PRODIVER"
"Promaster","PROMASTER"
"'Promaster","'PROMASTER"
"Pu'","PU'"
"Puppies","PUPPIES"
"Pyramid","PYRAMID"
"Quadro","QUADRO"
"Quilting","QUILTING"
"Radiomir","RADIOMIR"
"Radius","RADIUS"
"'Radius","'RADIUS"
"Railway","RAILWAY"
"'Railway","'RAILWAY"
"Railways","RAILWAYS"
"Raised","RAISED"
"Raku","RAKU"
"Ravine","RAVINE"
"'Ravynn'","'RAVYNN'"
"Raymond","RAYMOND"
"Read","READ"
"Rebels","REBELS"
"Rectanglar","RECTANGLAR"
"'Rectangulaire","'RECTANGULAIRE"
"Rectangulares","RECTANGULARES"
"'Rectangulares'","'RECTANGULARES'"
"Redondos","REDONDOS"
"Regents","REGENTS"
"Regetta","REGETTA"
"Relief","RELIEF"
"Removal","REMOVAL"
"Revi","REVI"
"Revue","REVUE"
"Rhodiumplated","RHODIUMPLATED"
"'Rivetta'","'RIVETTA'"
"Roberto","ROBERTO"
"Rolex","ROLEX"
"Romano","ROMANO"
"Rosetone","ROSETONE"
"Ross","ROSS"
"'RoyalMarine'","'ROYALMARINE'"
"'s","'S"
"Sandblasted","SANDBLASTED"
"'Sandown'","'SANDOWN'"
"Saturnalia","SATURNALIA"
"'Saturnos","'SATURNOS"
"'Scouter'","'SCOUTER'"
"Scubador","SCUBADOR"
"Seated","SEATED"
"'Seila","'SEILA"
"'Serein'","'SEREIN'"
"Serenada","SERENADA"
"Serenada'","SERENADA'"
"Sesame","SESAME"
"Sexy","SEXY"
"Seya","SEYA"
"Shihao","SHIHAO"
"Ship","SHIP"
"'Shotgun'","'SHOTGUN'"
"Silhoutte","SILHOUTTE"
"'Silverjet'","'SILVERJET'"
"Silverplated","SILVERPLATED"
"'Silverstone'","'SILVERSTONE'"
"Silvertne","SILVERTNE"
"Silvetone","SILVETONE"
"Simply","SIMPLY"
"'Simply","'SIMPLY"
"Singing","SINGING"
"'Six-T'","'SIX-T'"
"'Sizzling'","'SIZZLING'"
"SkullFace","SKULLFACE"
"Slappers","SLAPPERS"
"'Sleet'","'SLEET'"
"Smoked","SMOKED"
"Snowman","SNOWMAN"
"Society","SOCIETY"
"Society'","SOCIETY'"
"Solotempo","SOLOTEMPO"
"Sonarch","SONARCH"
"Sons","SONS"
"Spacely","SPACELY"
"Spacematic","SPACEMATIC"
"'Specialist'","'SPECIALIST'"
"Sportwatch","SPORTWATCH"
"SQDrive","SQDRIVE"
"Squelette'","SQUELETTE'"
"St.","ST."
"Stackable","STACKABLE"
"Stanless","STANLESS"
"Stap","STAP"
"'Starglitz'","'STARGLITZ'"
"Starlette","STARLETTE"
"Statue","STATUE"
"Stein","STEIN"
"Steinhausen","STEINHAUSEN"
"Steller","STELLER"
"'Steprock'","'STEPROCK'"
"Stich","STICH"
"Stienhausen","STIENHAUSEN"
"Stitching","STITCHING"
"Stratford","STRATFORD"
"'Stratford","'STRATFORD"
"'Stratford'","'STRATFORD'"
"Stratosphere'","STRATOSPHERE'"
"'Stratosphere'","'STRATOSPHERE'"
"Strawberries","STRAWBERRIES"
"Stuhrling","STUHRLING"
"Stylish","STYLISH"
"'Subaqua/Sport'","'SUBAQUA/SPORT'"
"Submariner","SUBMARINER"
"'Submersible'","'SUBMERSIBLE'"
"Sugary","SUGARY"
"Swan","SWAN"
"Sweetness","SWEETNESS"
"Swill","SWILL"
"Tach","TACH"
"Tacymeter","TACYMETER"
"Tamano","TAMANO"
"'Tanglewood'","'TANGLEWOOD'"
"Tasche","TASCHE"
"Teardrop","TEARDROP"
"Tekton'","TEKTON'"
"'Temo'","'TEMO'"
"Tendence","TENDENCE"
"'Terrano'","'TERRANO'"
"Texans","TEXANS"
"Texture","TEXTURE"
"Theme","THEME"
"Thierry","THIERRY"
"Thommen","THOMMEN"
"Thousands","THOUSANDS"
"'Thousands","'THOUSANDS"
"'Throttle'","'THROTTLE'"
"Tigers","TIGERS"
"TimeGreen","TIMEGREEN"
"TimeMaster","TIMEMASTER"
"Timepiece","TIMEPIECE"
"Timetech","TIMETECH"
"Tinker","TINKER"
"Tivoli","TIVOLI"
"Topaz","TOPAZ"
"Topring","TOPRING"
"Topstitched","TOPSTITCHED"
"Torina","TORINA"
"Trackmaster","TRACKMASTER"
"Transmission","TRANSMISSION"
"Transparency","TRANSPARENCY"
"Transperent","TRANSPERENT"
"'Trapeze'","'TRAPEZE'"
"Traviata","TRAVIATA"
"Treasures","TREASURES"
"Tressa","TRESSA"
"Triangular","TRIANGULAR"
"Tribella'","TRIBELLA'"
"'Tropics'","'TROPICS'"
"Turtles","TURTLES"
"Tuskeege","TUSKEEGE"
"Tuskegee","TUSKEGEE"
"'Tuskegee","'TUSKEGEE"
"Twotone","TWOTONE"
"Ulysse","ULYSSE"
"Unicorn","UNICORN"
"Unlisted","UNLISTED"
"Uptown","UPTOWN"
"'Uptown","'UPTOWN"
"Valerie","VALERIE"
"Valet","VALET"
"'Variance'","'VARIANCE'"
"Venezia","VENEZIA"
"Vernier","VERNIER"
"'Versaci'","'VERSACI'"
"Viaduct","VIADUCT"
"Viajero","VIAJERO"
"Vicotry","VICOTRY"
"'Vikki'","'VIKKI'"
"Visodate","VISODATE"
"Visodate'","VISODATE'"
"Volare","VOLARE"
"Volo","VOLO"
"Volo'","VOLO'"
"Volunteers","VOLUNTEERS"
"w/","W/"
"w/Exhibiton","W/EXHIBITON"
"Waldorf","WALDORF"
"Waldorf'","WALDORF'"
"Wan","WAN"
"Wars","WARS"
"Watchbox","WATCHBOX"
"Waving","WAVING"
"Ways","WAYS"
"Weed","WEED"
"Weil","WEIL"
"Westport","WESTPORT"
"Wheat","WHEAT"
"Whtie","WHTIE"
"Widgi'","WIDGI'"
"Wildcats","WILDCATS"
"Wildflower","WILDFLOWER"
"'Wildflower'","'WILDFLOWER'"
"Wiliams","WILIAMS"
"Winchester","WINCHESTER"
"'Winchester'","'WINCHESTER'"
"Winsor'","WINSOR'"
"Womans","WOMANS"
"Worldtimer","WORLDTIMER"
"Wyler","WYLER"
"Xezo","XEZO"
"Yachtmaster","YACHTMASTER"
"Yoshi","YOSHI"
"Yves","YVES"
"Zebralicious","ZEBRALICIOUS"
"Zeno","ZENO"
"Zirconia","ZIRCONIA"
"Zirconia/","ZIRCONIA/"

http://www.softinterface.com/MD%5CDocument-Comparison-Software.htm