LINQ To DataSet Samples - Join Operators
Join - simple
Simple join over two tables
Public Sub DataSetLinq118()
Dim customers = TestDS.Tables("Customers").AsEnumerable()
Dim orders = TestDS.Tables("Orders").AsEnumerable()
Dim smallOrders = customers.Join(orders, Function(o) o.Field(Of String)("CustomerID"), _
Function(c) c.Field(Of String)("CustomerID"), _
Function(c, o) _
New With {.CustomerID = c.Field(Of String)("CustomerID"), _
.OrderID = o.Field(Of Integer)("OrderID"), _
.Total = o.Field(Of Decimal)("Total")})
ObjectDumper.Write(smallOrders)
End Sub
Result:
CustomerID=ALFKI OrderID=10643 Total=814.50
CustomerID=ALFKI OrderID=10692 Total=878.00
CustomerID=ALFKI OrderID=10702 Total=330.00
CustomerID=ALFKI OrderID=10835 Total=845.80
CustomerID=ALFKI OrderID=10952 Total=471.20
CustomerID=ALFKI OrderID=11011 Total=933.50
CustomerID=ANATR OrderID=10308 Total=88.80
CustomerID=ANATR OrderID=10625 Total=479.75
CustomerID=ANATR OrderID=10759 Total=320.00
CustomerID=ANATR OrderID=10926 Total=514.40
CustomerID=ANTON OrderID=10365 Total=403.20
CustomerID=ANTON OrderID=10507 Total=749.06
CustomerID=ANTON OrderID=10535 Total=1940.85
CustomerID=ANTON OrderID=10573 Total=2082.00
CustomerID=ANTON OrderID=10677 Total=813.36
CustomerID=ANTON OrderID=10682 Total=375.50
CustomerID=ANTON OrderID=10856 Total=660.00
CustomerID=AROUT OrderID=10355 Total=480.00
CustomerID=AROUT OrderID=10383 Total=899.00
CustomerID=AROUT OrderID=10453 Total=407.70
CustomerID=AROUT OrderID=10558 Total=2142.90
CustomerID=AROUT OrderID=10707 Total=1641.00
CustomerID=AROUT OrderID=10741 Total=228.00
CustomerID=AROUT OrderID=10743 Total=319.20
CustomerID=AROUT OrderID=10768 Total=1477.00
CustomerID=AROUT OrderID=10793 Total=191.10
CustomerID=AROUT OrderID=10864 Total=282.00
CustomerID=AROUT OrderID=10920 Total=390.00
CustomerID=AROUT OrderID=10953 Total=4441.25
CustomerID=AROUT OrderID=11016 Total=491.50
CustomerID=BERGS OrderID=10278 Total=1488.80
CustomerID=BERGS OrderID=10280 Total=613.20
CustomerID=BERGS OrderID=10384 Total=2222.40
CustomerID=BERGS OrderID=10444 Total=1031.70
CustomerID=BERGS OrderID=10445 Total=174.90
CustomerID=BERGS OrderID=10524 Total=3192.65
CustomerID=BERGS OrderID=10572 Total=1501.08
CustomerID=BERGS OrderID=10626 Total=1503.60
CustomerID=BERGS OrderID=10654 Total=601.83
CustomerID=BERGS OrderID=10672 Total=3815.25
CustomerID=BERGS OrderID=10689 Total=472.50
CustomerID=BERGS OrderID=10733 Total=1459.00
CustomerID=BERGS OrderID=10778 Total=96.50
CustomerID=BERGS OrderID=10837 Total=1064.50
CustomerID=BERGS OrderID=10857 Total=2048.21
CustomerID=BERGS OrderID=10866 Total=1096.20
CustomerID=BERGS OrderID=10875 Total=709.55
CustomerID=BERGS OrderID=10924 Total=1835.70
CustomerID=BLAUS OrderID=10501 Total=149.00
CustomerID=BLAUS OrderID=10509 Total=136.80
CustomerID=BLAUS OrderID=10582 Total=330.00
CustomerID=BLAUS OrderID=10614 Total=464.00
CustomerID=BLAUS OrderID=10853 Total=625.00
CustomerID=BLAUS OrderID=10956 Total=677.00
CustomerID=BLAUS OrderID=11058 Total=858.00
CustomerID=BLONP OrderID=10265 Total=1176.00
CustomerID=BLONP OrderID=10297 Total=1420.00
CustomerID=BLONP OrderID=10360 Total=7390.20
CustomerID=BLONP OrderID=10436 Total=1994.52
CustomerID=BLONP OrderID=10449 Total=1838.20
CustomerID=BLONP OrderID=10559 Total=520.41
CustomerID=BLONP OrderID=10566 Total=1761.00
CustomerID=BLONP OrderID=10584 Total=593.75
CustomerID=BLONP OrderID=10628 Total=450.00
CustomerID=BLONP OrderID=10679 Total=660.00
CustomerID=BLONP OrderID=10826 Total=730.00
CustomerID=BOLID OrderID=10326 Total=982.00
CustomerID=BOLID OrderID=10801 Total=3026.85
CustomerID=BOLID OrderID=10970 Total=224.00
CustomerID=BONAP OrderID=10331 Total=88.50
CustomerID=BONAP OrderID=10340 Total=2436.18
CustomerID=BONAP OrderID=10362 Total=1549.60
CustomerID=BONAP OrderID=10470 Total=1820.80
CustomerID=BONAP OrderID=10511 Total=2550.00
CustomerID=BONAP OrderID=10525 Total=818.40
CustomerID=BONAP OrderID=10663 Total=1930.40
CustomerID=BONAP OrderID=10715 Total=1296.00
CustomerID=BONAP OrderID=10730 Total=484.26
CustomerID=BONAP OrderID=10732 Total=360.00
CustomerID=BONAP OrderID=10755 Total=1948.50
CustomerID=BONAP OrderID=10827 Total=843.00
CustomerID=BONAP OrderID=10871 Total=1979.23
CustomerID=BONAP OrderID=10876 Total=917.00
CustomerID=BONAP OrderID=10932 Total=1788.63
CustomerID=BONAP OrderID=10940 Total=360.00
CustomerID=BONAP OrderID=11076 Total=792.75
CustomerID=BOTTM OrderID=10389 Total=1832.80
CustomerID=BOTTM OrderID=10410 Total=802.00
CustomerID=BOTTM OrderID=10411 Total=966.80
CustomerID=BOTTM OrderID=10431 Total=1892.25
CustomerID=BOTTM OrderID=10492 Total=851.20
CustomerID=BOTTM OrderID=10742 Total=3118.00
CustomerID=BOTTM OrderID=10918 Total=1447.50
CustomerID=BOTTM OrderID=10944 Total=1025.32
CustomerID=BOTTM OrderID=10949 Total=4422.00
CustomerID=BOTTM OrderID=10975 Total=717.50
CustomerID=BOTTM OrderID=10982 Total=1014.00
CustomerID=BOTTM OrderID=11027 Total=877.72
CustomerID=BOTTM OrderID=11045 Total=1309.50
CustomerID=BOTTM OrderID=11048 Total=525.00
CustomerID=BSBEV OrderID=10289 Total=479.40
CustomerID=BSBEV OrderID=10471 Total=1328.00
CustomerID=BSBEV OrderID=10484 Total=386.20
CustomerID=BSBEV OrderID=10538 Total=139.80
CustomerID=BSBEV OrderID=10539 Total=355.50
CustomerID=BSBEV OrderID=10578 Total=477.00
CustomerID=BSBEV OrderID=10599 Total=493.00
CustomerID=BSBEV OrderID=10943 Total=711.00
CustomerID=BSBEV OrderID=10947 Total=220.00
CustomerID=BSBEV OrderID=11023 Total=1500.00
CustomerID=CACTU OrderID=10521 Total=225.50
CustomerID=CACTU OrderID=10782 Total=12.50
CustomerID=CACTU OrderID=10819 Total=477.00
CustomerID=CACTU OrderID=10881 Total=150.00
CustomerID=CACTU OrderID=10937 Total=644.80
CustomerID=CACTU OrderID=11054 Total=305.00
CustomerID=CENTC OrderID=10259 Total=100.80
CustomerID=CHOPS OrderID=10254 Total=556.62
CustomerID=CHOPS OrderID=10370 Total=1117.60
CustomerID=CHOPS OrderID=10519 Total=2314.20
CustomerID=CHOPS OrderID=10731 Total=1890.50
CustomerID=CHOPS OrderID=10746 Total=2311.70
CustomerID=CHOPS OrderID=10966 Total=1098.46
CustomerID=CHOPS OrderID=11029 Total=1286.80
CustomerID=CHOPS OrderID=11041 Total=1773.00
CustomerID=COMMI OrderID=10290 Total=2169.00
CustomerID=COMMI OrderID=10466 Total=216.00
CustomerID=COMMI OrderID=10494 Total=912.00
CustomerID=COMMI OrderID=10969 Total=108.00
CustomerID=COMMI OrderID=11042 Total=405.75
CustomerID=CONSH OrderID=10435 Total=631.60
CustomerID=CONSH OrderID=10462 Total=156.00
CustomerID=CONSH OrderID=10848 Total=931.50
CustomerID=DRACD OrderID=10363 Total=447.20
CustomerID=DRACD OrderID=10391 Total=86.40
CustomerID=DRACD OrderID=10797 Total=420.00
CustomerID=DRACD OrderID=10825 Total=1030.76
CustomerID=DRACD OrderID=11036 Total=1692.00
CustomerID=DRACD OrderID=11067 Total=86.85
CustomerID=DUMON OrderID=10311 Total=268.80
CustomerID=DUMON OrderID=10609 Total=424.00
CustomerID=DUMON OrderID=10683 Total=63.00
CustomerID=DUMON OrderID=10890 Total=860.10
CustomerID=EASTC OrderID=10364 Total=950.00
CustomerID=EASTC OrderID=10400 Total=3063.00
CustomerID=EASTC OrderID=10532 Total=796.35
CustomerID=EASTC OrderID=10726 Total=655.00
CustomerID=EASTC OrderID=10987 Total=2772.00
CustomerID=EASTC OrderID=11024 Total=1966.81
CustomerID=EASTC OrderID=11047 Total=817.88
CustomerID=EASTC OrderID=11056 Total=3740.00
CustomerID=ERNSH OrderID=10258 Total=1614.88
CustomerID=ERNSH OrderID=10263 Total=1873.80
CustomerID=ERNSH OrderID=10351 Total=5398.72
CustomerID=ERNSH OrderID=10368 Total=1689.78
CustomerID=ERNSH OrderID=10382 Total=2900.00
CustomerID=ERNSH OrderID=10390 Total=2090.88
CustomerID=ERNSH OrderID=10402 Total=2713.50
CustomerID=ERNSH OrderID=10403 Total=855.02
CustomerID=ERNSH OrderID=10430 Total=4899.20
CustomerID=ERNSH OrderID=10442 Total=1792.00
CustomerID=ERNSH OrderID=10514 Total=8623.45
CustomerID=ERNSH OrderID=10571 Total=550.59
CustomerID=ERNSH OrderID=10595 Total=4725.00
CustomerID=ERNSH OrderID=10633 Total=5510.59
CustomerID=ERNSH OrderID=10667 Total=1536.80
CustomerID=ERNSH OrderID=10698 Total=3436.44
CustomerID=ERNSH OrderID=10764 Total=2286.00
CustomerID=ERNSH OrderID=10771 Total=344.00
CustomerID=ERNSH OrderID=10773 Total=2030.40
CustomerID=ERNSH OrderID=10776 Total=6635.28
CustomerID=ERNSH OrderID=10795 Total=2158.00
CustomerID=ERNSH OrderID=10836 Total=4705.50
CustomerID=ERNSH OrderID=10854 Total=2966.50
CustomerID=ERNSH OrderID=10895 Total=6379.40
CustomerID=ERNSH OrderID=10968 Total=1408.00
CustomerID=ERNSH OrderID=10979 Total=4813.50
CustomerID=ERNSH OrderID=10990 Total=4288.85
CustomerID=ERNSH OrderID=11008 Total=4680.90
CustomerID=ERNSH OrderID=11017 Total=6750.00
CustomerID=ERNSH OrderID=11072 Total=5218.00
CustomerID=FAMIA OrderID=10347 Total=814.42
CustomerID=FAMIA OrderID=10386 Total=166.00
CustomerID=FAMIA OrderID=10414 Total=224.83
CustomerID=FAMIA OrderID=10512 Total=525.30
CustomerID=FAMIA OrderID=10581 Total=310.00
CustomerID=FAMIA OrderID=10650 Total=1779.20
CustomerID=FAMIA OrderID=10725 Total=287.80
CustomerID=FOLIG OrderID=10408 Total=1622.40
CustomerID=FOLIG OrderID=10480 Total=756.00
CustomerID=FOLIG OrderID=10634 Total=4985.50
CustomerID=FOLIG OrderID=10763 Total=616.00
CustomerID=FOLIG OrderID=10789 Total=3687.00
CustomerID=FOLKO OrderID=10264 Total=695.62
CustomerID=FOLKO OrderID=10327 Total=1810.00
CustomerID=FOLKO OrderID=10378 Total=103.20
CustomerID=FOLKO OrderID=10434 Total=321.12
CustomerID=FOLKO OrderID=10460 Total=176.10
CustomerID=FOLKO OrderID=10533 Total=2222.20
CustomerID=FOLKO OrderID=10561 Total=2844.50
CustomerID=FOLKO OrderID=10703 Total=2545.00
CustomerID=FOLKO OrderID=10762 Total=4337.00
CustomerID=FOLKO OrderID=10774 Total=868.75
CustomerID=FOLKO OrderID=10824 Total=250.80
CustomerID=FOLKO OrderID=10880 Total=1500.00
CustomerID=FOLKO OrderID=10902 Total=863.43
CustomerID=FOLKO OrderID=10955 Total=74.40
CustomerID=FOLKO OrderID=10977 Total=2233.00
CustomerID=FOLKO OrderID=10980 Total=248.00
CustomerID=FOLKO OrderID=10993 Total=4895.44
CustomerID=FOLKO OrderID=11001 Total=2769.00
CustomerID=FOLKO OrderID=11050 Total=810.00
CustomerID=FRANK OrderID=10267 Total=3536.60
CustomerID=FRANK OrderID=10337 Total=2467.00
CustomerID=FRANK OrderID=10342 Total=1840.64
CustomerID=FRANK OrderID=10396 Total=1903.80
CustomerID=FRANK OrderID=10488 Total=1512.00
CustomerID=FRANK OrderID=10560 Total=1072.42
CustomerID=FRANK OrderID=10623 Total=1336.95
CustomerID=FRANK OrderID=10653 Total=1083.15
CustomerID=FRANK OrderID=10670 Total=2301.75
CustomerID=FRANK OrderID=10675 Total=1423.00
CustomerID=FRANK OrderID=10717 Total=1270.75
CustomerID=FRANK OrderID=10791 Total=1829.76
CustomerID=FRANK OrderID=10859 Total=1078.69
CustomerID=FRANK OrderID=10929 Total=1174.75
CustomerID=FRANK OrderID=11012 Total=2825.30
CustomerID=FRANR OrderID=10671 Total=920.10
CustomerID=FRANR OrderID=10860 Total=519.00
CustomerID=FRANR OrderID=10971 Total=1733.06
CustomerID=FRANS OrderID=10422 Total=49.80
CustomerID=FRANS OrderID=10710 Total=93.50
CustomerID=FRANS OrderID=10753 Total=88.00
CustomerID=FRANS OrderID=10807 Total=18.40
CustomerID=FRANS OrderID=11026 Total=1030.00
CustomerID=FRANS OrderID=11060 Total=266.00
CustomerID=FURIB OrderID=10328 Total=1168.00
CustomerID=FURIB OrderID=10352 Total=136.30
CustomerID=FURIB OrderID=10464 Total=1609.28
CustomerID=FURIB OrderID=10491 Total=259.50
CustomerID=FURIB OrderID=10551 Total=1677.30
CustomerID=FURIB OrderID=10604 Total=230.85
CustomerID=FURIB OrderID=10664 Total=1288.39
CustomerID=FURIB OrderID=10963 Total=57.80
CustomerID=GALED OrderID=10366 Total=136.00
CustomerID=GALED OrderID=10426 Total=338.20
CustomerID=GALED OrderID=10568 Total=155.00
CustomerID=GALED OrderID=10887 Total=70.00
CustomerID=GALED OrderID=10928 Total=137.50
CustomerID=GODOS OrderID=10303 Total=1117.80
CustomerID=GODOS OrderID=10550 Total=683.30
CustomerID=GODOS OrderID=10629 Total=2775.05
CustomerID=GODOS OrderID=10872 Total=2058.46
CustomerID=GODOS OrderID=10874 Total=310.00
CustomerID=GODOS OrderID=10888 Total=605.00
CustomerID=GODOS OrderID=10911 Total=858.00
CustomerID=GODOS OrderID=10948 Total=2362.25
CustomerID=GODOS OrderID=11009 Total=616.50
CustomerID=GODOS OrderID=11037 Total=60.00
CustomerID=GOURL OrderID=10423 Total=1020.00
CustomerID=GOURL OrderID=10652 Total=318.84
CustomerID=GOURL OrderID=10685 Total=801.10
CustomerID=GOURL OrderID=10709 Total=3424.00
CustomerID=GOURL OrderID=10734 Total=1498.35
CustomerID=GOURL OrderID=10777 Total=224.00
CustomerID=GOURL OrderID=10790 Total=722.50
CustomerID=GOURL OrderID=10959 Total=131.75
CustomerID=GOURL OrderID=11049 Total=273.60
CustomerID=GREAL OrderID=10528 Total=392.20
CustomerID=GREAL OrderID=10589 Total=72.00
CustomerID=GREAL OrderID=10616 Total=4807.00
CustomerID=GREAL OrderID=10617 Total=1402.50
CustomerID=GREAL OrderID=10656 Total=604.22
CustomerID=GREAL OrderID=10681 Total=1287.40
CustomerID=GREAL OrderID=10816 Total=8446.45
CustomerID=GREAL OrderID=10936 Total=456.00
CustomerID=GREAL OrderID=11006 Total=329.68
CustomerID=GREAL OrderID=11040 Total=200.00
CustomerID=GREAL OrderID=11061 Total=510.00
CustomerID=GROSR OrderID=10268 Total=1101.20
CustomerID=GROSR OrderID=10785 Total=387.50
CustomerID=HANAR OrderID=10250 Total=1552.60
CustomerID=HANAR OrderID=10253 Total=1444.80
CustomerID=HANAR OrderID=10541 Total=1946.52
CustomerID=HANAR OrderID=10645 Total=1535.00
CustomerID=HANAR OrderID=10690 Total=862.50
CustomerID=HANAR OrderID=10770 Total=236.25
CustomerID=HANAR OrderID=10783 Total=1442.50
CustomerID=HANAR OrderID=10886 Total=3127.50
CustomerID=HANAR OrderID=10903 Total=932.05
CustomerID=HANAR OrderID=10922 Total=742.50
CustomerID=HANAR OrderID=10925 Total=475.15
CustomerID=HANAR OrderID=10981 Total=15810.00
CustomerID=HANAR OrderID=11022 Total=1402.00
CustomerID=HANAR OrderID=11052 Total=1332.00
CustomerID=HILAA OrderID=10257 Total=1119.90
CustomerID=HILAA OrderID=10395 Total=2122.92
CustomerID=HILAA OrderID=10476 Total=180.48
CustomerID=HILAA OrderID=10486 Total=1272.00
CustomerID=HILAA OrderID=10490 Total=3163.20
CustomerID=HILAA OrderID=10498 Total=575.00
CustomerID=HILAA OrderID=10552 Total=880.50
CustomerID=HILAA OrderID=10601 Total=2285.00
CustomerID=HILAA OrderID=10613 Total=353.20
CustomerID=HILAA OrderID=10641 Total=2054.00
CustomerID=HILAA OrderID=10705 Total=378.00
CustomerID=HILAA OrderID=10796 Total=2341.36
CustomerID=HILAA OrderID=10863 Total=441.15
CustomerID=HILAA OrderID=10901 Total=934.50
CustomerID=HILAA OrderID=10957 Total=1762.70
CustomerID=HILAA OrderID=10960 Total=265.35
CustomerID=HILAA OrderID=10976 Total=912.00
CustomerID=HILAA OrderID=11055 Total=1727.50
CustomerID=HUNGC OrderID=10375 Total=338.00
CustomerID=HUNGC OrderID=10394 Total=442.00
CustomerID=HUNGC OrderID=10415 Total=102.40
CustomerID=HUNGC OrderID=10600 Total=479.80
CustomerID=HUNGC OrderID=10660 Total=1701.00
CustomerID=HUNGO OrderID=10298 Total=2645.00
CustomerID=HUNGO OrderID=10309 Total=1762.00
CustomerID=HUNGO OrderID=10335 Total=2036.16
CustomerID=HUNGO OrderID=10373 Total=1366.40
CustomerID=HUNGO OrderID=10380 Total=1313.82
CustomerID=HUNGO OrderID=10429 Total=1441.38
CustomerID=HUNGO OrderID=10503 Total=2048.50
CustomerID=HUNGO OrderID=10516 Total=2381.05
CustomerID=HUNGO OrderID=10567 Total=2519.00
CustomerID=HUNGO OrderID=10646 Total=1446.00
CustomerID=HUNGO OrderID=10661 Total=562.60
CustomerID=HUNGO OrderID=10687 Total=4960.90
CustomerID=HUNGO OrderID=10701 Total=2864.50
CustomerID=HUNGO OrderID=10712 Total=1233.48
CustomerID=HUNGO OrderID=10736 Total=997.00
CustomerID=HUNGO OrderID=10897 Total=10835.24
CustomerID=HUNGO OrderID=10912 Total=6200.55
CustomerID=HUNGO OrderID=10985 Total=2023.38
CustomerID=HUNGO OrderID=11063 Total=1342.95
CustomerID=ISLAT OrderID=10315 Total=516.80
CustomerID=ISLAT OrderID=10318 Total=240.40
CustomerID=ISLAT OrderID=10321 Total=144.00
CustomerID=ISLAT OrderID=10473 Total=230.40
CustomerID=ISLAT OrderID=10621 Total=758.50
CustomerID=ISLAT OrderID=10674 Total=45.00
CustomerID=ISLAT OrderID=10749 Total=1080.00
CustomerID=ISLAT OrderID=10798 Total=446.60
CustomerID=ISLAT OrderID=10829 Total=1764.00
CustomerID=ISLAT OrderID=10933 Total=920.60
CustomerID=KOENE OrderID=10323 Total=164.40
CustomerID=KOENE OrderID=10325 Total=1497.00
CustomerID=KOENE OrderID=10456 Total=557.60
CustomerID=KOENE OrderID=10457 Total=1584.00
CustomerID=KOENE OrderID=10468 Total=717.60
CustomerID=KOENE OrderID=10506 Total=415.80
CustomerID=KOENE OrderID=10542 Total=469.11
CustomerID=KOENE OrderID=10630 Total=903.60
CustomerID=KOENE OrderID=10718 Total=3463.00
CustomerID=KOENE OrderID=10799 Total=1553.50
CustomerID=KOENE OrderID=10817 Total=10952.84
CustomerID=KOENE OrderID=10849 Total=967.82
CustomerID=KOENE OrderID=10893 Total=5502.11
CustomerID=KOENE OrderID=11028 Total=2160.00
CustomerID=LACOR OrderID=10858 Total=649.00
CustomerID=LACOR OrderID=10927 Total=800.00
CustomerID=LACOR OrderID=10972 Total=251.50
CustomerID=LACOR OrderID=10973 Total=291.55
CustomerID=LAMAI OrderID=10350 Total=642.06
CustomerID=LAMAI OrderID=10358 Total=429.40
CustomerID=LAMAI OrderID=10371 Total=72.96
CustomerID=LAMAI OrderID=10413 Total=2123.20
CustomerID=LAMAI OrderID=10425 Total=360.00
CustomerID=LAMAI OrderID=10454 Total=331.20
CustomerID=LAMAI OrderID=10493 Total=608.40
CustomerID=LAMAI OrderID=10500 Total=523.26
CustomerID=LAMAI OrderID=10610 Total=299.25
CustomerID=LAMAI OrderID=10631 Total=55.80
CustomerID=LAMAI OrderID=10787 Total=2622.76
CustomerID=LAMAI OrderID=10832 Total=475.11
CustomerID=LAMAI OrderID=10923 Total=748.80
CustomerID=LAMAI OrderID=11051 Total=36.00
CustomerID=LAUGB OrderID=10495 Total=278.00
CustomerID=LAUGB OrderID=10620 Total=57.50
CustomerID=LAUGB OrderID=10810 Total=187.00
CustomerID=LAZYK OrderID=10482 Total=147.00
CustomerID=LAZYK OrderID=10545 Total=210.00
CustomerID=LEHMS OrderID=10279 Total=351.00
CustomerID=LEHMS OrderID=10284 Total=1170.38
CustomerID=LEHMS OrderID=10343 Total=1584.00
CustomerID=LEHMS OrderID=10497 Total=1380.60
CustomerID=LEHMS OrderID=10522 Total=2318.24
CustomerID=LEHMS OrderID=10534 Total=465.70
CustomerID=LEHMS OrderID=10536 Total=1645.00
CustomerID=LEHMS OrderID=10557 Total=1152.50
CustomerID=LEHMS OrderID=10592 Total=516.47
CustomerID=LEHMS OrderID=10593 Total=1994.40
CustomerID=LEHMS OrderID=10772 Total=3603.22
CustomerID=LEHMS OrderID=10862 Total=581.00
CustomerID=LEHMS OrderID=10891 Total=368.93
CustomerID=LEHMS OrderID=10934 Total=500.00
CustomerID=LEHMS OrderID=11070 Total=1629.98
CustomerID=LETSS OrderID=10579 Total=317.75
CustomerID=LETSS OrderID=10719 Total=844.25
CustomerID=LETSS OrderID=10735 Total=536.40
CustomerID=LETSS OrderID=10884 Total=1378.07
CustomerID=LILAS OrderID=10283 Total=1414.80
CustomerID=LILAS OrderID=10296 Total=1050.60
CustomerID=LILAS OrderID=10330 Total=1649.00
CustomerID=LILAS OrderID=10357 Total=1167.68
CustomerID=LILAS OrderID=10381 Total=112.00
CustomerID=LILAS OrderID=10461 Total=1538.70
CustomerID=LILAS OrderID=10499 Total=1412.00
CustomerID=LILAS OrderID=10543 Total=1504.50
CustomerID=LILAS OrderID=10780 Total=720.00
CustomerID=LILAS OrderID=10823 Total=2826.00
CustomerID=LILAS OrderID=10899 Total=122.40
CustomerID=LILAS OrderID=10997 Total=1885.00
CustomerID=LILAS OrderID=11065 Total=189.42
CustomerID=LILAS OrderID=11071 Total=484.50
CustomerID=LINOD OrderID=10405 Total=400.00
CustomerID=LINOD OrderID=10485 Total=1584.00
CustomerID=LINOD OrderID=10638 Total=2720.05
CustomerID=LINOD OrderID=10697 Total=805.42
CustomerID=LINOD OrderID=10729 Total=1850.00
CustomerID=LINOD OrderID=10811 Total=852.00
CustomerID=LINOD OrderID=10838 Total=1938.38
CustomerID=LINOD OrderID=10840 Total=211.20
CustomerID=LINOD OrderID=10919 Total=1122.80
CustomerID=LINOD OrderID=10954 Total=1659.54
CustomerID=LINOD OrderID=11014 Total=243.18
CustomerID=LINOD OrderID=11039 Total=3090.00
CustomerID=LONEP OrderID=10307 Total=424.00
CustomerID=LONEP OrderID=10317 Total=288.00
CustomerID=LONEP OrderID=10544 Total=417.20
CustomerID=LONEP OrderID=10662 Total=125.00
CustomerID=LONEP OrderID=10665 Total=1295.00
CustomerID=LONEP OrderID=10867 Total=98.40
CustomerID=LONEP OrderID=10883 Total=36.00
CustomerID=LONEP OrderID=11018 Total=1575.00
CustomerID=MAGAA OrderID=10275 Total=291.84
CustomerID=MAGAA OrderID=10300 Total=608.00
CustomerID=MAGAA OrderID=10404 Total=1591.25
CustomerID=MAGAA OrderID=10467 Total=235.20
CustomerID=MAGAA OrderID=10635 Total=1326.22
CustomerID=MAGAA OrderID=10754 Total=55.20
CustomerID=MAGAA OrderID=10784 Total=1488.00
CustomerID=MAGAA OrderID=10818 Total=833.00
CustomerID=MAGAA OrderID=10939 Total=637.50
CustomerID=MAGAA OrderID=10950 Total=110.00
CustomerID=MAISD OrderID=10529 Total=946.00
CustomerID=MAISD OrderID=10649 Total=1434.00
CustomerID=MAISD OrderID=10760 Total=2917.00
CustomerID=MAISD OrderID=10892 Total=2090.00
CustomerID=MAISD OrderID=10896 Total=750.50
CustomerID=MAISD OrderID=10978 Total=1303.20
CustomerID=MAISD OrderID=11004 Total=295.38
CustomerID=MEREP OrderID=10332 Total=1786.88
CustomerID=MEREP OrderID=10339 Total=3354.00
CustomerID=MEREP OrderID=10376 Total=399.00
CustomerID=MEREP OrderID=10424 Total=9194.56
CustomerID=MEREP OrderID=10439 Total=1078.00
CustomerID=MEREP OrderID=10505 Total=147.90
CustomerID=MEREP OrderID=10565 Total=639.90
CustomerID=MEREP OrderID=10570 Total=2465.25
CustomerID=MEREP OrderID=10590 Total=1101.00
CustomerID=MEREP OrderID=10605 Total=4109.70
CustomerID=MEREP OrderID=10618 Total=2697.50
CustomerID=MEREP OrderID=10619 Total=1260.00
CustomerID=MEREP OrderID=10724 Total=638.50
CustomerID=MORGK OrderID=10277 Total=1200.80
CustomerID=MORGK OrderID=10575 Total=2147.40
CustomerID=MORGK OrderID=10699 Total=114.00
CustomerID=MORGK OrderID=10779 Total=1335.00
CustomerID=MORGK OrderID=10945 Total=245.00
CustomerID=NORTS OrderID=10517 Total=352.00
CustomerID=NORTS OrderID=10752 Total=252.00
CustomerID=NORTS OrderID=11057 Total=45.00
CustomerID=OCEAN OrderID=10409 Total=319.20
CustomerID=OCEAN OrderID=10531 Total=110.00
CustomerID=OCEAN OrderID=10898 Total=30.00
CustomerID=OCEAN OrderID=10958 Total=781.00
CustomerID=OCEAN OrderID=10986 Total=2220.00
CustomerID=OLDWO OrderID=10260 Total=1504.65
CustomerID=OLDWO OrderID=10305 Total=3741.30
CustomerID=OLDWO OrderID=10338 Total=934.50
CustomerID=OLDWO OrderID=10441 Total=1755.00
CustomerID=OLDWO OrderID=10594 Total=565.50
CustomerID=OLDWO OrderID=10680 Total=1261.88
CustomerID=OLDWO OrderID=10706 Total=1893.00
CustomerID=OLDWO OrderID=10855 Total=2227.89
CustomerID=OLDWO OrderID=10965 Total=848.00
CustomerID=OLDWO OrderID=11034 Total=539.40
CustomerID=OTTIK OrderID=10407 Total=1194.00
CustomerID=OTTIK OrderID=10508 Total=240.00
CustomerID=OTTIK OrderID=10554 Total=1728.52
CustomerID=OTTIK OrderID=10580 Total=1013.74
CustomerID=OTTIK OrderID=10684 Total=1768.00
CustomerID=OTTIK OrderID=10766 Total=2310.00
CustomerID=OTTIK OrderID=10833 Total=906.93
CustomerID=OTTIK OrderID=10999 Total=1197.95
CustomerID=OTTIK OrderID=11020 Total=632.40
CustomerID=PERIC OrderID=10322 Total=112.00
CustomerID=PERIC OrderID=10354 Total=568.80
CustomerID=PERIC OrderID=10474 Total=1249.10
CustomerID=PERIC OrderID=10502 Total=816.30
CustomerID=PERIC OrderID=10995 Total=1196.00
CustomerID=PERIC OrderID=11073 Total=300.00
CustomerID=PICCO OrderID=10353 Total=8593.28
CustomerID=PICCO OrderID=10392 Total=1440.00
CustomerID=PICCO OrderID=10427 Total=651.00
CustomerID=PICCO OrderID=10489 Total=439.20
CustomerID=PICCO OrderID=10530 Total=4180.00
CustomerID=PICCO OrderID=10597 Total=718.08
CustomerID=PICCO OrderID=10686 Total=1404.45
CustomerID=PICCO OrderID=10747 Total=1912.85
CustomerID=PICCO OrderID=10844 Total=735.00
CustomerID=PICCO OrderID=11053 Total=3055.00
CustomerID=PRINI OrderID=10336 Total=285.12
CustomerID=PRINI OrderID=10397 Total=716.72
CustomerID=PRINI OrderID=10433 Total=851.20
CustomerID=PRINI OrderID=10477 Total=558.00
CustomerID=PRINI OrderID=10808 Total=1411.00
CustomerID=PRINI OrderID=11007 Total=2633.90
CustomerID=QUEDE OrderID=10261 Total=448.00
CustomerID=QUEDE OrderID=10291 Total=497.52
CustomerID=QUEDE OrderID=10379 Total=863.28
CustomerID=QUEDE OrderID=10421 Total=1194.27
CustomerID=QUEDE OrderID=10587 Total=807.38
CustomerID=QUEDE OrderID=10647 Total=636.00
CustomerID=QUEDE OrderID=10720 Total=550.00
CustomerID=QUEDE OrderID=10794 Total=314.76
CustomerID=QUEDE OrderID=10989 Total=1353.60
CustomerID=QUEEN OrderID=10372 Total=9210.90
CustomerID=QUEEN OrderID=10406 Total=1830.78
CustomerID=QUEEN OrderID=10487 Total=889.70
CustomerID=QUEEN OrderID=10637 Total=2761.94
CustomerID=QUEEN OrderID=10659 Total=1227.02
CustomerID=QUEEN OrderID=10704 Total=595.50
CustomerID=QUEEN OrderID=10728 Total=1296.75
CustomerID=QUEEN OrderID=10786 Total=1531.08
CustomerID=QUEEN OrderID=10868 Total=1920.60
CustomerID=QUEEN OrderID=10913 Total=768.75
CustomerID=QUEEN OrderID=10914 Total=537.50
CustomerID=QUEEN OrderID=10961 Total=1119.90
CustomerID=QUEEN OrderID=11068 Total=2027.08
CustomerID=QUICK OrderID=10273 Total=2037.28
CustomerID=QUICK OrderID=10285 Total=1743.36
CustomerID=QUICK OrderID=10286 Total=3016.00
CustomerID=QUICK OrderID=10313 Total=182.40
CustomerID=QUICK OrderID=10345 Total=2924.80
CustomerID=QUICK OrderID=10361 Total=2046.24
CustomerID=QUICK OrderID=10418 Total=1814.80
CustomerID=QUICK OrderID=10451 Total=3849.66
CustomerID=QUICK OrderID=10515 Total=9921.30
CustomerID=QUICK OrderID=10527 Total=1503.00
CustomerID=QUICK OrderID=10540 Total=10191.70
CustomerID=QUICK OrderID=10549 Total=3554.28
CustomerID=QUICK OrderID=10588 Total=3120.00
CustomerID=QUICK OrderID=10658 Total=4464.60
CustomerID=QUICK OrderID=10691 Total=10164.80
CustomerID=QUICK OrderID=10694 Total=4825.00
CustomerID=QUICK OrderID=10721 Total=923.88
CustomerID=QUICK OrderID=10745 Total=4529.80
CustomerID=QUICK OrderID=10765 Total=1515.60
CustomerID=QUICK OrderID=10788 Total=731.50
CustomerID=QUICK OrderID=10845 Total=3812.70
CustomerID=QUICK OrderID=10865 Total=16387.50
CustomerID=QUICK OrderID=10878 Total=1539.00
CustomerID=QUICK OrderID=10938 Total=2731.88
CustomerID=QUICK OrderID=10962 Total=3584.00
CustomerID=QUICK OrderID=10991 Total=2296.00
CustomerID=QUICK OrderID=10996 Total=560.00
CustomerID=QUICK OrderID=11021 Total=6306.24
CustomerID=RANCH OrderID=10448 Total=443.40
CustomerID=RANCH OrderID=10716 Total=706.00
CustomerID=RANCH OrderID=10828 Total=932.00
CustomerID=RANCH OrderID=10916 Total=686.70
CustomerID=RANCH OrderID=11019 Total=76.00
CustomerID=RATTC OrderID=10262 Total=584.00
CustomerID=RATTC OrderID=10272 Total=1456.00
CustomerID=RATTC OrderID=10294 Total=1887.60
CustomerID=RATTC OrderID=10314 Total=2094.30
CustomerID=RATTC OrderID=10316 Total=2835.00
CustomerID=RATTC OrderID=10346 Total=1618.88
CustomerID=RATTC OrderID=10401 Total=3868.60
CustomerID=RATTC OrderID=10479 Total=10495.60
CustomerID=RATTC OrderID=10564 Total=1234.05
CustomerID=RATTC OrderID=10569 Total=890.00
CustomerID=RATTC OrderID=10598 Total=2388.50
CustomerID=RATTC OrderID=10761 Total=507.00
CustomerID=RATTC OrderID=10820 Total=1140.00
CustomerID=RATTC OrderID=10852 Total=2984.00
CustomerID=RATTC OrderID=10889 Total=11380.00
CustomerID=RATTC OrderID=10988 Total=3574.80
CustomerID=RATTC OrderID=11000 Total=903.75
CustomerID=RATTC OrderID=11077 Total=1255.72
CustomerID=REGGC OrderID=10288 Total=80.10
CustomerID=REGGC OrderID=10428 Total=192.00
CustomerID=REGGC OrderID=10443 Total=517.44
CustomerID=REGGC OrderID=10562 Total=488.70
CustomerID=REGGC OrderID=10586 Total=23.80
CustomerID=REGGC OrderID=10655 Total=154.40
CustomerID=REGGC OrderID=10727 Total=1624.50
CustomerID=REGGC OrderID=10812 Total=1692.80
CustomerID=REGGC OrderID=10908 Total=663.10
CustomerID=REGGC OrderID=10942 Total=560.00
CustomerID=REGGC OrderID=11010 Total=645.00
CustomerID=REGGC OrderID=11062 Total=406.40
CustomerID=RICAR OrderID=10287 Total=819.00
CustomerID=RICAR OrderID=10299 Total=349.50
CustomerID=RICAR OrderID=10447 Total=914.40
CustomerID=RICAR OrderID=10481 Total=1472.00
CustomerID=RICAR OrderID=10563 Total=965.00
CustomerID=RICAR OrderID=10622 Total=560.00
CustomerID=RICAR OrderID=10648 Total=372.38
CustomerID=RICAR OrderID=10813 Total=602.40
CustomerID=RICAR OrderID=10851 Total=2603.00
CustomerID=RICAR OrderID=10877 Total=1955.12
CustomerID=RICAR OrderID=11059 Total=1838.00
CustomerID=RICSU OrderID=10255 Total=2490.50
CustomerID=RICSU OrderID=10419 Total=2097.60
CustomerID=RICSU OrderID=10537 Total=1823.80
CustomerID=RICSU OrderID=10666 Total=4666.94
CustomerID=RICSU OrderID=10751 Total=1631.48
CustomerID=RICSU OrderID=10758 Total=1644.60
CustomerID=RICSU OrderID=10931 Total=799.20
CustomerID=RICSU OrderID=10951 Total=458.76
CustomerID=RICSU OrderID=11033 Total=3232.80
CustomerID=RICSU OrderID=11075 Total=498.10
CustomerID=ROMEY OrderID=10281 Total=86.50
CustomerID=ROMEY OrderID=10282 Total=155.40
CustomerID=ROMEY OrderID=10306 Total=498.50
CustomerID=ROMEY OrderID=10917 Total=365.89
CustomerID=ROMEY OrderID=11013 Total=361.00
CustomerID=SANTG OrderID=10387 Total=1058.40
CustomerID=SANTG OrderID=10520 Total=200.00
CustomerID=SANTG OrderID=10639 Total=500.00
CustomerID=SANTG OrderID=10831 Total=2684.40
CustomerID=SANTG OrderID=10909 Total=670.00
CustomerID=SANTG OrderID=11015 Total=622.35
CustomerID=SAVEA OrderID=10324 Total=5275.72
CustomerID=SAVEA OrderID=10393 Total=2556.95
CustomerID=SAVEA OrderID=10398 Total=2505.60
CustomerID=SAVEA OrderID=10440 Total=4924.14
CustomerID=SAVEA OrderID=10452 Total=2018.50
CustomerID=SAVEA OrderID=10510 Total=4707.54
CustomerID=SAVEA OrderID=10555 Total=2944.40
CustomerID=SAVEA OrderID=10603 Total=1483.00
CustomerID=SAVEA OrderID=10607 Total=6475.40
CustomerID=SAVEA OrderID=10612 Total=6375.00
CustomerID=SAVEA OrderID=10627 Total=1185.75
CustomerID=SAVEA OrderID=10657 Total=4371.60
CustomerID=SAVEA OrderID=10678 Total=5256.50
CustomerID=SAVEA OrderID=10700 Total=1638.40
CustomerID=SAVEA OrderID=10711 Total=4451.70
CustomerID=SAVEA OrderID=10713 Total=2827.90
CustomerID=SAVEA OrderID=10714 Total=2205.75
CustomerID=SAVEA OrderID=10722 Total=1570.00
CustomerID=SAVEA OrderID=10748 Total=2196.00
CustomerID=SAVEA OrderID=10757 Total=3082.00
CustomerID=SAVEA OrderID=10815 Total=40.00
CustomerID=SAVEA OrderID=10847 Total=4931.92
CustomerID=SAVEA OrderID=10882 Total=892.64
CustomerID=SAVEA OrderID=10894 Total=2753.10
CustomerID=SAVEA OrderID=10941 Total=4011.75
CustomerID=SAVEA OrderID=10983 Total=720.90
CustomerID=SAVEA OrderID=10984 Total=1809.75
CustomerID=SAVEA OrderID=11002 Total=1811.10
CustomerID=SAVEA OrderID=11030 Total=12615.05
CustomerID=SAVEA OrderID=11031 Total=2393.50
CustomerID=SAVEA OrderID=11064 Total=4330.40
CustomerID=SEVES OrderID=10359 Total=3471.68
CustomerID=SEVES OrderID=10377 Total=863.60
CustomerID=SEVES OrderID=10388 Total=1228.80
CustomerID=SEVES OrderID=10472 Total=1036.80
CustomerID=SEVES OrderID=10523 Total=2444.31
CustomerID=SEVES OrderID=10547 Total=1792.80
CustomerID=SEVES OrderID=10800 Total=1468.94
CustomerID=SEVES OrderID=10804 Total=2278.40
CustomerID=SEVES OrderID=10869 Total=1630.00
CustomerID=SIMOB OrderID=10341 Total=352.60
CustomerID=SIMOB OrderID=10417 Total=11188.40
CustomerID=SIMOB OrderID=10556 Total=835.20
CustomerID=SIMOB OrderID=10642 Total=696.00
CustomerID=SIMOB OrderID=10669 Total=570.00
CustomerID=SIMOB OrderID=10802 Total=2942.81
CustomerID=SIMOB OrderID=11074 Total=232.08
CustomerID=SPECD OrderID=10738 Total=52.35
CustomerID=SPECD OrderID=10907 Total=108.50
CustomerID=SPECD OrderID=10964 Total=2052.50
CustomerID=SPECD OrderID=11043 Total=210.00
CustomerID=SPLIR OrderID=10271 Total=48.00
CustomerID=SPLIR OrderID=10329 Total=4578.43
CustomerID=SPLIR OrderID=10349 Total=141.60
CustomerID=SPLIR OrderID=10369 Total=2390.40
CustomerID=SPLIR OrderID=10385 Total=691.20
CustomerID=SPLIR OrderID=10432 Total=485.00
CustomerID=SPLIR OrderID=10756 Total=1990.00
CustomerID=SPLIR OrderID=10821 Total=678.00
CustomerID=SPLIR OrderID=10974 Total=439.00
CustomerID=SUPRD OrderID=10252 Total=3597.90
CustomerID=SUPRD OrderID=10302 Total=2708.80
CustomerID=SUPRD OrderID=10458 Total=3891.00
CustomerID=SUPRD OrderID=10463 Total=713.30
CustomerID=SUPRD OrderID=10475 Total=1505.18
CustomerID=SUPRD OrderID=10767 Total=28.00
CustomerID=SUPRD OrderID=10841 Total=4581.00
CustomerID=SUPRD OrderID=10846 Total=1112.00
CustomerID=SUPRD OrderID=10885 Total=1209.00
CustomerID=SUPRD OrderID=10930 Total=2255.50
CustomerID=SUPRD OrderID=11035 Total=1754.50
CustomerID=SUPRD OrderID=11038 Total=732.60
CustomerID=THEBI OrderID=10310 Total=336.00
CustomerID=THEBI OrderID=10708 Total=180.40
CustomerID=THEBI OrderID=10805 Total=2775.00
CustomerID=THEBI OrderID=10992 Total=69.60
CustomerID=THECR OrderID=10624 Total=1393.24
CustomerID=THECR OrderID=10775 Total=228.00
CustomerID=THECR OrderID=11003 Total=326.00
CustomerID=TOMSP OrderID=10438 Total=454.00
CustomerID=TOMSP OrderID=10446 Total=246.24
CustomerID=TOMSP OrderID=10548 Total=240.10
CustomerID=TOMSP OrderID=10608 Total=1064.00
CustomerID=TOMSP OrderID=10967 Total=910.40
CustomerID=TORTU OrderID=10276 Total=420.00
CustomerID=TORTU OrderID=10293 Total=848.70
CustomerID=TORTU OrderID=10304 Total=954.40
CustomerID=TORTU OrderID=10319 Total=1191.20
CustomerID=TORTU OrderID=10518 Total=4150.05
CustomerID=TORTU OrderID=10576 Total=838.45
CustomerID=TORTU OrderID=10676 Total=534.85
CustomerID=TORTU OrderID=10842 Total=975.00
CustomerID=TORTU OrderID=10915 Total=539.50
CustomerID=TORTU OrderID=11069 Total=360.00
CustomerID=TRADH OrderID=10249 Total=1863.40
CustomerID=TRADH OrderID=10292 Total=1296.00
CustomerID=TRADH OrderID=10496 Total=190.00
CustomerID=TRADH OrderID=10606 Total=1130.40
CustomerID=TRADH OrderID=10830 Total=1974.00
CustomerID=TRADH OrderID=10834 Total=1432.71
CustomerID=TRADH OrderID=10839 Total=827.55
CustomerID=TRAIH OrderID=10574 Total=764.30
CustomerID=TRAIH OrderID=10577 Total=569.00
CustomerID=TRAIH OrderID=10822 Total=237.90
CustomerID=VAFFE OrderID=10367 Total=834.20
CustomerID=VAFFE OrderID=10399 Total=1765.60
CustomerID=VAFFE OrderID=10465 Total=2518.00
CustomerID=VAFFE OrderID=10591 Total=812.50
CustomerID=VAFFE OrderID=10602 Total=48.75
CustomerID=VAFFE OrderID=10688 Total=3160.60
CustomerID=VAFFE OrderID=10744 Total=736.00
CustomerID=VAFFE OrderID=10769 Total=1684.28
CustomerID=VAFFE OrderID=10921 Total=1936.00
CustomerID=VAFFE OrderID=10946 Total=1407.50
CustomerID=VAFFE OrderID=10994 Total=940.50
CustomerID=VICTE OrderID=10251 Total=654.06
CustomerID=VICTE OrderID=10334 Total=144.80
CustomerID=VICTE OrderID=10450 Total=425.12
CustomerID=VICTE OrderID=10459 Total=1659.20
CustomerID=VICTE OrderID=10478 Total=471.20
CustomerID=VICTE OrderID=10546 Total=2812.00
CustomerID=VICTE OrderID=10806 Total=439.60
CustomerID=VICTE OrderID=10814 Total=1788.45
CustomerID=VICTE OrderID=10843 Total=159.00
CustomerID=VICTE OrderID=10850 Total=629.00
CustomerID=VINET OrderID=10274 Total=538.60
CustomerID=VINET OrderID=10295 Total=121.60
CustomerID=VINET OrderID=10737 Total=139.80
CustomerID=VINET OrderID=10739 Total=240.00
CustomerID=WANDK OrderID=10301 Total=755.00
CustomerID=WANDK OrderID=10312 Total=1614.80
CustomerID=WANDK OrderID=10348 Total=363.60
CustomerID=WANDK OrderID=10356 Total=1106.40
CustomerID=WANDK OrderID=10513 Total=1942.00
CustomerID=WANDK OrderID=10632 Total=589.00
CustomerID=WANDK OrderID=10640 Total=708.75
CustomerID=WANDK OrderID=10651 Total=397.80
CustomerID=WANDK OrderID=10668 Total=625.28
CustomerID=WANDK OrderID=11046 Total=1485.80
CustomerID=WARTH OrderID=10266 Total=346.56
CustomerID=WARTH OrderID=10270 Total=1376.00
CustomerID=WARTH OrderID=10320 Total=516.00
CustomerID=WARTH OrderID=10333 Total=877.20
CustomerID=WARTH OrderID=10412 Total=334.80
CustomerID=WARTH OrderID=10416 Total=720.00
CustomerID=WARTH OrderID=10437 Total=393.00
CustomerID=WARTH OrderID=10455 Total=2684.00
CustomerID=WARTH OrderID=10526 Total=1151.40
CustomerID=WARTH OrderID=10553 Total=1546.30
CustomerID=WARTH OrderID=10583 Total=2237.50
CustomerID=WARTH OrderID=10636 Total=629.50
CustomerID=WARTH OrderID=10750 Total=1590.56
CustomerID=WARTH OrderID=10781 Total=975.88
CustomerID=WARTH OrderID=11025 Total=270.00
CustomerID=WELLI OrderID=10256 Total=517.80
CustomerID=WELLI OrderID=10420 Total=1707.84
CustomerID=WELLI OrderID=10585 Total=142.50
CustomerID=WELLI OrderID=10644 Total=1371.80
CustomerID=WELLI OrderID=10803 Total=1193.01
CustomerID=WELLI OrderID=10809 Total=140.00
CustomerID=WELLI OrderID=10900 Total=33.75
CustomerID=WELLI OrderID=10905 Total=342.00
CustomerID=WELLI OrderID=10935 Total=619.50
CustomerID=WHITC OrderID=10269 Total=642.20
CustomerID=WHITC OrderID=10344 Total=2296.00
CustomerID=WHITC OrderID=10469 Total=956.68
CustomerID=WHITC OrderID=10483 Total=668.80
CustomerID=WHITC OrderID=10504 Total=1388.50
CustomerID=WHITC OrderID=10596 Total=1180.88
CustomerID=WHITC OrderID=10693 Total=2071.20
CustomerID=WHITC OrderID=10696 Total=996.00
CustomerID=WHITC OrderID=10723 Total=468.45
CustomerID=WHITC OrderID=10740 Total=1416.00
CustomerID=WHITC OrderID=10861 Total=3523.40
CustomerID=WHITC OrderID=10904 Total=1924.25
CustomerID=WHITC OrderID=11032 Total=8902.50
CustomerID=WHITC OrderID=11066 Total=928.75
CustomerID=WILMK OrderID=10248 Total=440.00
CustomerID=WILMK OrderID=10615 Total=120.00
CustomerID=WILMK OrderID=10673 Total=412.35
CustomerID=WILMK OrderID=10695 Total=642.00
CustomerID=WILMK OrderID=10873 Total=336.80
CustomerID=WILMK OrderID=10879 Total=611.30
CustomerID=WILMK OrderID=10910 Total=452.90
CustomerID=WILMK OrderID=11005 Total=586.00
CustomerID=WOLZA OrderID=10374 Total=459.00
CustomerID=WOLZA OrderID=10611 Total=808.00
CustomerID=WOLZA OrderID=10792 Total=399.85
CustomerID=WOLZA OrderID=10870 Total=160.00
CustomerID=WOLZA OrderID=10906 Total=427.50
CustomerID=WOLZA OrderID=10998 Total=686.00
CustomerID=WOLZA OrderID=11044 Total=591.60
Join with grouped results
Join with grouped results
Public Sub DataSetLinq119()
Dim customers = TestDS.Tables("Customers").AsEnumerable()
Dim orders = TestDS.Tables("Orders").AsEnumerable()
Dim groupedOrders = customers.Join(orders, Function(o) o.Field(Of String)("CustomerID"), _
Function(c) c.Field(Of String)("CustomerID"), _
Function(c, o) _
New With {.CustomerID = c.Field(Of String)("CustomerID"), _
.OrderID = o.Field(Of Integer)("OrderID"), _
.Total = o.Field(Of Decimal)("Total")}) _
.GroupBy(Function(r) r.OrderID)
For Each group In groupedOrders
For Each order In group
ObjectDumper.Write(order)
Next
Next
End Sub
Result:
CustomerID=ALFKI OrderID=10643 Total=814.50
CustomerID=ALFKI OrderID=10692 Total=878.00
CustomerID=ALFKI OrderID=10702 Total=330.00
CustomerID=ALFKI OrderID=10835 Total=845.80
CustomerID=ALFKI OrderID=10952 Total=471.20
CustomerID=ALFKI OrderID=11011 Total=933.50
CustomerID=ANATR OrderID=10308 Total=88.80
CustomerID=ANATR OrderID=10625 Total=479.75
CustomerID=ANATR OrderID=10759 Total=320.00
CustomerID=ANATR OrderID=10926 Total=514.40
CustomerID=ANTON OrderID=10365 Total=403.20
CustomerID=ANTON OrderID=10507 Total=749.06
CustomerID=ANTON OrderID=10535 Total=1940.85
CustomerID=ANTON OrderID=10573 Total=2082.00
CustomerID=ANTON OrderID=10677 Total=813.36
CustomerID=ANTON OrderID=10682 Total=375.50
CustomerID=ANTON OrderID=10856 Total=660.00
CustomerID=AROUT OrderID=10355 Total=480.00
CustomerID=AROUT OrderID=10383 Total=899.00
CustomerID=AROUT OrderID=10453 Total=407.70
CustomerID=AROUT OrderID=10558 Total=2142.90
CustomerID=AROUT OrderID=10707 Total=1641.00
CustomerID=AROUT OrderID=10741 Total=228.00
CustomerID=AROUT OrderID=10743 Total=319.20
CustomerID=AROUT OrderID=10768 Total=1477.00
CustomerID=AROUT OrderID=10793 Total=191.10
CustomerID=AROUT OrderID=10864 Total=282.00
CustomerID=AROUT OrderID=10920 Total=390.00
CustomerID=AROUT OrderID=10953 Total=4441.25
CustomerID=AROUT OrderID=11016 Total=491.50
CustomerID=BERGS OrderID=10278 Total=1488.80
CustomerID=BERGS OrderID=10280 Total=613.20
CustomerID=BERGS OrderID=10384 Total=2222.40
CustomerID=BERGS OrderID=10444 Total=1031.70
CustomerID=BERGS OrderID=10445 Total=174.90
CustomerID=BERGS OrderID=10524 Total=3192.65
CustomerID=BERGS OrderID=10572 Total=1501.08
CustomerID=BERGS OrderID=10626 Total=1503.60
CustomerID=BERGS OrderID=10654 Total=601.83
CustomerID=BERGS OrderID=10672 Total=3815.25
CustomerID=BERGS OrderID=10689 Total=472.50
CustomerID=BERGS OrderID=10733 Total=1459.00
CustomerID=BERGS OrderID=10778 Total=96.50
CustomerID=BERGS OrderID=10837 Total=1064.50
CustomerID=BERGS OrderID=10857 Total=2048.21
CustomerID=BERGS OrderID=10866 Total=1096.20
CustomerID=BERGS OrderID=10875 Total=709.55
CustomerID=BERGS OrderID=10924 Total=1835.70
CustomerID=BLAUS OrderID=10501 Total=149.00
CustomerID=BLAUS OrderID=10509 Total=136.80
CustomerID=BLAUS OrderID=10582 Total=330.00
CustomerID=BLAUS OrderID=10614 Total=464.00
CustomerID=BLAUS OrderID=10853 Total=625.00
CustomerID=BLAUS OrderID=10956 Total=677.00
CustomerID=BLAUS OrderID=11058 Total=858.00
CustomerID=BLONP OrderID=10265 Total=1176.00
CustomerID=BLONP OrderID=10297 Total=1420.00
CustomerID=BLONP OrderID=10360 Total=7390.20
CustomerID=BLONP OrderID=10436 Total=1994.52
CustomerID=BLONP OrderID=10449 Total=1838.20
CustomerID=BLONP OrderID=10559 Total=520.41
CustomerID=BLONP OrderID=10566 Total=1761.00
CustomerID=BLONP OrderID=10584 Total=593.75
CustomerID=BLONP OrderID=10628 Total=450.00
CustomerID=BLONP OrderID=10679 Total=660.00
CustomerID=BLONP OrderID=10826 Total=730.00
CustomerID=BOLID OrderID=10326 Total=982.00
CustomerID=BOLID OrderID=10801 Total=3026.85
CustomerID=BOLID OrderID=10970 Total=224.00
CustomerID=BONAP OrderID=10331 Total=88.50
CustomerID=BONAP OrderID=10340 Total=2436.18
CustomerID=BONAP OrderID=10362 Total=1549.60
CustomerID=BONAP OrderID=10470 Total=1820.80
CustomerID=BONAP OrderID=10511 Total=2550.00
CustomerID=BONAP OrderID=10525 Total=818.40
CustomerID=BONAP OrderID=10663 Total=1930.40
CustomerID=BONAP OrderID=10715 Total=1296.00
CustomerID=BONAP OrderID=10730 Total=484.26
CustomerID=BONAP OrderID=10732 Total=360.00
CustomerID=BONAP OrderID=10755 Total=1948.50
CustomerID=BONAP OrderID=10827 Total=843.00
CustomerID=BONAP OrderID=10871 Total=1979.23
CustomerID=BONAP OrderID=10876 Total=917.00
CustomerID=BONAP OrderID=10932 Total=1788.63
CustomerID=BONAP OrderID=10940 Total=360.00
CustomerID=BONAP OrderID=11076 Total=792.75
CustomerID=BOTTM OrderID=10389 Total=1832.80
CustomerID=BOTTM OrderID=10410 Total=802.00
CustomerID=BOTTM OrderID=10411 Total=966.80
CustomerID=BOTTM OrderID=10431 Total=1892.25
CustomerID=BOTTM OrderID=10492 Total=851.20
CustomerID=BOTTM OrderID=10742 Total=3118.00
CustomerID=BOTTM OrderID=10918 Total=1447.50
CustomerID=BOTTM OrderID=10944 Total=1025.32
CustomerID=BOTTM OrderID=10949 Total=4422.00
CustomerID=BOTTM OrderID=10975 Total=717.50
CustomerID=BOTTM OrderID=10982 Total=1014.00
CustomerID=BOTTM OrderID=11027 Total=877.72
CustomerID=BOTTM OrderID=11045 Total=1309.50
CustomerID=BOTTM OrderID=11048 Total=525.00
CustomerID=BSBEV OrderID=10289 Total=479.40
CustomerID=BSBEV OrderID=10471 Total=1328.00
CustomerID=BSBEV OrderID=10484 Total=386.20
CustomerID=BSBEV OrderID=10538 Total=139.80
CustomerID=BSBEV OrderID=10539 Total=355.50
CustomerID=BSBEV OrderID=10578 Total=477.00
CustomerID=BSBEV OrderID=10599 Total=493.00
CustomerID=BSBEV OrderID=10943 Total=711.00
CustomerID=BSBEV OrderID=10947 Total=220.00
CustomerID=BSBEV OrderID=11023 Total=1500.00
CustomerID=CACTU OrderID=10521 Total=225.50
CustomerID=CACTU OrderID=10782 Total=12.50
CustomerID=CACTU OrderID=10819 Total=477.00
CustomerID=CACTU OrderID=10881 Total=150.00
CustomerID=CACTU OrderID=10937 Total=644.80
CustomerID=CACTU OrderID=11054 Total=305.00
CustomerID=CENTC OrderID=10259 Total=100.80
CustomerID=CHOPS OrderID=10254 Total=556.62
CustomerID=CHOPS OrderID=10370 Total=1117.60
CustomerID=CHOPS OrderID=10519 Total=2314.20
CustomerID=CHOPS OrderID=10731 Total=1890.50
CustomerID=CHOPS OrderID=10746 Total=2311.70
CustomerID=CHOPS OrderID=10966 Total=1098.46
CustomerID=CHOPS OrderID=11029 Total=1286.80
CustomerID=CHOPS OrderID=11041 Total=1773.00
CustomerID=COMMI OrderID=10290 Total=2169.00
CustomerID=COMMI OrderID=10466 Total=216.00
CustomerID=COMMI OrderID=10494 Total=912.00
CustomerID=COMMI OrderID=10969 Total=108.00
CustomerID=COMMI OrderID=11042 Total=405.75
CustomerID=CONSH OrderID=10435 Total=631.60
CustomerID=CONSH OrderID=10462 Total=156.00
CustomerID=CONSH OrderID=10848 Total=931.50
CustomerID=DRACD OrderID=10363 Total=447.20
CustomerID=DRACD OrderID=10391 Total=86.40
CustomerID=DRACD OrderID=10797 Total=420.00
CustomerID=DRACD OrderID=10825 Total=1030.76
CustomerID=DRACD OrderID=11036 Total=1692.00
CustomerID=DRACD OrderID=11067 Total=86.85
CustomerID=DUMON OrderID=10311 Total=268.80
CustomerID=DUMON OrderID=10609 Total=424.00
CustomerID=DUMON OrderID=10683 Total=63.00
CustomerID=DUMON OrderID=10890 Total=860.10
CustomerID=EASTC OrderID=10364 Total=950.00
CustomerID=EASTC OrderID=10400 Total=3063.00
CustomerID=EASTC OrderID=10532 Total=796.35
CustomerID=EASTC OrderID=10726 Total=655.00
CustomerID=EASTC OrderID=10987 Total=2772.00
CustomerID=EASTC OrderID=11024 Total=1966.81
CustomerID=EASTC OrderID=11047 Total=817.88
CustomerID=EASTC OrderID=11056 Total=3740.00
CustomerID=ERNSH OrderID=10258 Total=1614.88
CustomerID=ERNSH OrderID=10263 Total=1873.80
CustomerID=ERNSH OrderID=10351 Total=5398.72
CustomerID=ERNSH OrderID=10368 Total=1689.78
CustomerID=ERNSH OrderID=10382 Total=2900.00
CustomerID=ERNSH OrderID=10390 Total=2090.88
CustomerID=ERNSH OrderID=10402 Total=2713.50
CustomerID=ERNSH OrderID=10403 Total=855.02
CustomerID=ERNSH OrderID=10430 Total=4899.20
CustomerID=ERNSH OrderID=10442 Total=1792.00
CustomerID=ERNSH OrderID=10514 Total=8623.45
CustomerID=ERNSH OrderID=10571 Total=550.59
CustomerID=ERNSH OrderID=10595 Total=4725.00
CustomerID=ERNSH OrderID=10633 Total=5510.59
CustomerID=ERNSH OrderID=10667 Total=1536.80
CustomerID=ERNSH OrderID=10698 Total=3436.44
CustomerID=ERNSH OrderID=10764 Total=2286.00
CustomerID=ERNSH OrderID=10771 Total=344.00
CustomerID=ERNSH OrderID=10773 Total=2030.40
CustomerID=ERNSH OrderID=10776 Total=6635.28
CustomerID=ERNSH OrderID=10795 Total=2158.00
CustomerID=ERNSH OrderID=10836 Total=4705.50
CustomerID=ERNSH OrderID=10854 Total=2966.50
CustomerID=ERNSH OrderID=10895 Total=6379.40
CustomerID=ERNSH OrderID=10968 Total=1408.00
CustomerID=ERNSH OrderID=10979 Total=4813.50
CustomerID=ERNSH OrderID=10990 Total=4288.85
CustomerID=ERNSH OrderID=11008 Total=4680.90
CustomerID=ERNSH OrderID=11017 Total=6750.00
CustomerID=ERNSH OrderID=11072 Total=5218.00
CustomerID=FAMIA OrderID=10347 Total=814.42
CustomerID=FAMIA OrderID=10386 Total=166.00
CustomerID=FAMIA OrderID=10414 Total=224.83
CustomerID=FAMIA OrderID=10512 Total=525.30
CustomerID=FAMIA OrderID=10581 Total=310.00
CustomerID=FAMIA OrderID=10650 Total=1779.20
CustomerID=FAMIA OrderID=10725 Total=287.80
CustomerID=FOLIG OrderID=10408 Total=1622.40
CustomerID=FOLIG OrderID=10480 Total=756.00
CustomerID=FOLIG OrderID=10634 Total=4985.50
CustomerID=FOLIG OrderID=10763 Total=616.00
CustomerID=FOLIG OrderID=10789 Total=3687.00
CustomerID=FOLKO OrderID=10264 Total=695.62
CustomerID=FOLKO OrderID=10327 Total=1810.00
CustomerID=FOLKO OrderID=10378 Total=103.20
CustomerID=FOLKO OrderID=10434 Total=321.12
CustomerID=FOLKO OrderID=10460 Total=176.10
CustomerID=FOLKO OrderID=10533 Total=2222.20
CustomerID=FOLKO OrderID=10561 Total=2844.50
CustomerID=FOLKO OrderID=10703 Total=2545.00
CustomerID=FOLKO OrderID=10762 Total=4337.00
CustomerID=FOLKO OrderID=10774 Total=868.75
CustomerID=FOLKO OrderID=10824 Total=250.80
CustomerID=FOLKO OrderID=10880 Total=1500.00
CustomerID=FOLKO OrderID=10902 Total=863.43
CustomerID=FOLKO OrderID=10955 Total=74.40
CustomerID=FOLKO OrderID=10977 Total=2233.00
CustomerID=FOLKO OrderID=10980 Total=248.00
CustomerID=FOLKO OrderID=10993 Total=4895.44
CustomerID=FOLKO OrderID=11001 Total=2769.00
CustomerID=FOLKO OrderID=11050 Total=810.00
CustomerID=FRANK OrderID=10267 Total=3536.60
CustomerID=FRANK OrderID=10337 Total=2467.00
CustomerID=FRANK OrderID=10342 Total=1840.64
CustomerID=FRANK OrderID=10396 Total=1903.80
CustomerID=FRANK OrderID=10488 Total=1512.00
CustomerID=FRANK OrderID=10560 Total=1072.42
CustomerID=FRANK OrderID=10623 Total=1336.95
CustomerID=FRANK OrderID=10653 Total=1083.15
CustomerID=FRANK OrderID=10670 Total=2301.75
CustomerID=FRANK OrderID=10675 Total=1423.00
CustomerID=FRANK OrderID=10717 Total=1270.75
CustomerID=FRANK OrderID=10791 Total=1829.76
CustomerID=FRANK OrderID=10859 Total=1078.69
CustomerID=FRANK OrderID=10929 Total=1174.75
CustomerID=FRANK OrderID=11012 Total=2825.30
CustomerID=FRANR OrderID=10671 Total=920.10
CustomerID=FRANR OrderID=10860 Total=519.00
CustomerID=FRANR OrderID=10971 Total=1733.06
CustomerID=FRANS OrderID=10422 Total=49.80
CustomerID=FRANS OrderID=10710 Total=93.50
CustomerID=FRANS OrderID=10753 Total=88.00
CustomerID=FRANS OrderID=10807 Total=18.40
CustomerID=FRANS OrderID=11026 Total=1030.00
CustomerID=FRANS OrderID=11060 Total=266.00
CustomerID=FURIB OrderID=10328 Total=1168.00
CustomerID=FURIB OrderID=10352 Total=136.30
CustomerID=FURIB OrderID=10464 Total=1609.28
CustomerID=FURIB OrderID=10491 Total=259.50
CustomerID=FURIB OrderID=10551 Total=1677.30
CustomerID=FURIB OrderID=10604 Total=230.85
CustomerID=FURIB OrderID=10664 Total=1288.39
CustomerID=FURIB OrderID=10963 Total=57.80
CustomerID=GALED OrderID=10366 Total=136.00
CustomerID=GALED OrderID=10426 Total=338.20
CustomerID=GALED OrderID=10568 Total=155.00
CustomerID=GALED OrderID=10887 Total=70.00
CustomerID=GALED OrderID=10928 Total=137.50
CustomerID=GODOS OrderID=10303 Total=1117.80
CustomerID=GODOS OrderID=10550 Total=683.30
CustomerID=GODOS OrderID=10629 Total=2775.05
CustomerID=GODOS OrderID=10872 Total=2058.46
CustomerID=GODOS OrderID=10874 Total=310.00
CustomerID=GODOS OrderID=10888 Total=605.00
CustomerID=GODOS OrderID=10911 Total=858.00
CustomerID=GODOS OrderID=10948 Total=2362.25
CustomerID=GODOS OrderID=11009 Total=616.50
CustomerID=GODOS OrderID=11037 Total=60.00
CustomerID=GOURL OrderID=10423 Total=1020.00
CustomerID=GOURL OrderID=10652 Total=318.84
CustomerID=GOURL OrderID=10685 Total=801.10
CustomerID=GOURL OrderID=10709 Total=3424.00
CustomerID=GOURL OrderID=10734 Total=1498.35
CustomerID=GOURL OrderID=10777 Total=224.00
CustomerID=GOURL OrderID=10790 Total=722.50
CustomerID=GOURL OrderID=10959 Total=131.75
CustomerID=GOURL OrderID=11049 Total=273.60
CustomerID=GREAL OrderID=10528 Total=392.20
CustomerID=GREAL OrderID=10589 Total=72.00
CustomerID=GREAL OrderID=10616 Total=4807.00
CustomerID=GREAL OrderID=10617 Total=1402.50
CustomerID=GREAL OrderID=10656 Total=604.22
CustomerID=GREAL OrderID=10681 Total=1287.40
CustomerID=GREAL OrderID=10816 Total=8446.45
CustomerID=GREAL OrderID=10936 Total=456.00
CustomerID=GREAL OrderID=11006 Total=329.68
CustomerID=GREAL OrderID=11040 Total=200.00
CustomerID=GREAL OrderID=11061 Total=510.00
CustomerID=GROSR OrderID=10268 Total=1101.20
CustomerID=GROSR OrderID=10785 Total=387.50
CustomerID=HANAR OrderID=10250 Total=1552.60
CustomerID=HANAR OrderID=10253 Total=1444.80
CustomerID=HANAR OrderID=10541 Total=1946.52
CustomerID=HANAR OrderID=10645 Total=1535.00
CustomerID=HANAR OrderID=10690 Total=862.50
CustomerID=HANAR OrderID=10770 Total=236.25
CustomerID=HANAR OrderID=10783 Total=1442.50
CustomerID=HANAR OrderID=10886 Total=3127.50
CustomerID=HANAR OrderID=10903 Total=932.05
CustomerID=HANAR OrderID=10922 Total=742.50
CustomerID=HANAR OrderID=10925 Total=475.15
CustomerID=HANAR OrderID=10981 Total=15810.00
CustomerID=HANAR OrderID=11022 Total=1402.00
CustomerID=HANAR OrderID=11052 Total=1332.00
CustomerID=HILAA OrderID=10257 Total=1119.90
CustomerID=HILAA OrderID=10395 Total=2122.92
CustomerID=HILAA OrderID=10476 Total=180.48
CustomerID=HILAA OrderID=10486 Total=1272.00
CustomerID=HILAA OrderID=10490 Total=3163.20
CustomerID=HILAA OrderID=10498 Total=575.00
CustomerID=HILAA OrderID=10552 Total=880.50
CustomerID=HILAA OrderID=10601 Total=2285.00
CustomerID=HILAA OrderID=10613 Total=353.20
CustomerID=HILAA OrderID=10641 Total=2054.00
CustomerID=HILAA OrderID=10705 Total=378.00
CustomerID=HILAA OrderID=10796 Total=2341.36
CustomerID=HILAA OrderID=10863 Total=441.15
CustomerID=HILAA OrderID=10901 Total=934.50
CustomerID=HILAA OrderID=10957 Total=1762.70
CustomerID=HILAA OrderID=10960 Total=265.35
CustomerID=HILAA OrderID=10976 Total=912.00
CustomerID=HILAA OrderID=11055 Total=1727.50
CustomerID=HUNGC OrderID=10375 Total=338.00
CustomerID=HUNGC OrderID=10394 Total=442.00
CustomerID=HUNGC OrderID=10415 Total=102.40
CustomerID=HUNGC OrderID=10600 Total=479.80
CustomerID=HUNGC OrderID=10660 Total=1701.00
CustomerID=HUNGO OrderID=10298 Total=2645.00
CustomerID=HUNGO OrderID=10309 Total=1762.00
CustomerID=HUNGO OrderID=10335 Total=2036.16
CustomerID=HUNGO OrderID=10373 Total=1366.40
CustomerID=HUNGO OrderID=10380 Total=1313.82
CustomerID=HUNGO OrderID=10429 Total=1441.38
CustomerID=HUNGO OrderID=10503 Total=2048.50
CustomerID=HUNGO OrderID=10516 Total=2381.05
CustomerID=HUNGO OrderID=10567 Total=2519.00
CustomerID=HUNGO OrderID=10646 Total=1446.00
CustomerID=HUNGO OrderID=10661 Total=562.60
CustomerID=HUNGO OrderID=10687 Total=4960.90
CustomerID=HUNGO OrderID=10701 Total=2864.50
CustomerID=HUNGO OrderID=10712 Total=1233.48
CustomerID=HUNGO OrderID=10736 Total=997.00
CustomerID=HUNGO OrderID=10897 Total=10835.24
CustomerID=HUNGO OrderID=10912 Total=6200.55
CustomerID=HUNGO OrderID=10985 Total=2023.38
CustomerID=HUNGO OrderID=11063 Total=1342.95
CustomerID=ISLAT OrderID=10315 Total=516.80
CustomerID=ISLAT OrderID=10318 Total=240.40
CustomerID=ISLAT OrderID=10321 Total=144.00
CustomerID=ISLAT OrderID=10473 Total=230.40
CustomerID=ISLAT OrderID=10621 Total=758.50
CustomerID=ISLAT OrderID=10674 Total=45.00
CustomerID=ISLAT OrderID=10749 Total=1080.00
CustomerID=ISLAT OrderID=10798 Total=446.60
CustomerID=ISLAT OrderID=10829 Total=1764.00
CustomerID=ISLAT OrderID=10933 Total=920.60
CustomerID=KOENE OrderID=10323 Total=164.40
CustomerID=KOENE OrderID=10325 Total=1497.00
CustomerID=KOENE OrderID=10456 Total=557.60
CustomerID=KOENE OrderID=10457 Total=1584.00
CustomerID=KOENE OrderID=10468 Total=717.60
CustomerID=KOENE OrderID=10506 Total=415.80
CustomerID=KOENE OrderID=10542 Total=469.11
CustomerID=KOENE OrderID=10630 Total=903.60
CustomerID=KOENE OrderID=10718 Total=3463.00
CustomerID=KOENE OrderID=10799 Total=1553.50
CustomerID=KOENE OrderID=10817 Total=10952.84
CustomerID=KOENE OrderID=10849 Total=967.82
CustomerID=KOENE OrderID=10893 Total=5502.11
CustomerID=KOENE OrderID=11028 Total=2160.00
CustomerID=LACOR OrderID=10858 Total=649.00
CustomerID=LACOR OrderID=10927 Total=800.00
CustomerID=LACOR OrderID=10972 Total=251.50
CustomerID=LACOR OrderID=10973 Total=291.55
CustomerID=LAMAI OrderID=10350 Total=642.06
CustomerID=LAMAI OrderID=10358 Total=429.40
CustomerID=LAMAI OrderID=10371 Total=72.96
CustomerID=LAMAI OrderID=10413 Total=2123.20
CustomerID=LAMAI OrderID=10425 Total=360.00
CustomerID=LAMAI OrderID=10454 Total=331.20
CustomerID=LAMAI OrderID=10493 Total=608.40
CustomerID=LAMAI OrderID=10500 Total=523.26
CustomerID=LAMAI OrderID=10610 Total=299.25
CustomerID=LAMAI OrderID=10631 Total=55.80
CustomerID=LAMAI OrderID=10787 Total=2622.76
CustomerID=LAMAI OrderID=10832 Total=475.11
CustomerID=LAMAI OrderID=10923 Total=748.80
CustomerID=LAMAI OrderID=11051 Total=36.00
CustomerID=LAUGB OrderID=10495 Total=278.00
CustomerID=LAUGB OrderID=10620 Total=57.50
CustomerID=LAUGB OrderID=10810 Total=187.00
CustomerID=LAZYK OrderID=10482 Total=147.00
CustomerID=LAZYK OrderID=10545 Total=210.00
CustomerID=LEHMS OrderID=10279 Total=351.00
CustomerID=LEHMS OrderID=10284 Total=1170.38
CustomerID=LEHMS OrderID=10343 Total=1584.00
CustomerID=LEHMS OrderID=10497 Total=1380.60
CustomerID=LEHMS OrderID=10522 Total=2318.24
CustomerID=LEHMS OrderID=10534 Total=465.70
CustomerID=LEHMS OrderID=10536 Total=1645.00
CustomerID=LEHMS OrderID=10557 Total=1152.50
CustomerID=LEHMS OrderID=10592 Total=516.47
CustomerID=LEHMS OrderID=10593 Total=1994.40
CustomerID=LEHMS OrderID=10772 Total=3603.22
CustomerID=LEHMS OrderID=10862 Total=581.00
CustomerID=LEHMS OrderID=10891 Total=368.93
CustomerID=LEHMS OrderID=10934 Total=500.00
CustomerID=LEHMS OrderID=11070 Total=1629.98
CustomerID=LETSS OrderID=10579 Total=317.75
CustomerID=LETSS OrderID=10719 Total=844.25
CustomerID=LETSS OrderID=10735 Total=536.40
CustomerID=LETSS OrderID=10884 Total=1378.07
CustomerID=LILAS OrderID=10283 Total=1414.80
CustomerID=LILAS OrderID=10296 Total=1050.60
CustomerID=LILAS OrderID=10330 Total=1649.00
CustomerID=LILAS OrderID=10357 Total=1167.68
CustomerID=LILAS OrderID=10381 Total=112.00
CustomerID=LILAS OrderID=10461 Total=1538.70
CustomerID=LILAS OrderID=10499 Total=1412.00
CustomerID=LILAS OrderID=10543 Total=1504.50
CustomerID=LILAS OrderID=10780 Total=720.00
CustomerID=LILAS OrderID=10823 Total=2826.00
CustomerID=LILAS OrderID=10899 Total=122.40
CustomerID=LILAS OrderID=10997 Total=1885.00
CustomerID=LILAS OrderID=11065 Total=189.42
CustomerID=LILAS OrderID=11071 Total=484.50
CustomerID=LINOD OrderID=10405 Total=400.00
CustomerID=LINOD OrderID=10485 Total=1584.00
CustomerID=LINOD OrderID=10638 Total=2720.05
CustomerID=LINOD OrderID=10697 Total=805.42
CustomerID=LINOD OrderID=10729 Total=1850.00
CustomerID=LINOD OrderID=10811 Total=852.00
CustomerID=LINOD OrderID=10838 Total=1938.38
CustomerID=LINOD OrderID=10840 Total=211.20
CustomerID=LINOD OrderID=10919 Total=1122.80
CustomerID=LINOD OrderID=10954 Total=1659.54
CustomerID=LINOD OrderID=11014 Total=243.18
CustomerID=LINOD OrderID=11039 Total=3090.00
CustomerID=LONEP OrderID=10307 Total=424.00
CustomerID=LONEP OrderID=10317 Total=288.00
CustomerID=LONEP OrderID=10544 Total=417.20
CustomerID=LONEP OrderID=10662 Total=125.00
CustomerID=LONEP OrderID=10665 Total=1295.00
CustomerID=LONEP OrderID=10867 Total=98.40
CustomerID=LONEP OrderID=10883 Total=36.00
CustomerID=LONEP OrderID=11018 Total=1575.00
CustomerID=MAGAA OrderID=10275 Total=291.84
CustomerID=MAGAA OrderID=10300 Total=608.00
CustomerID=MAGAA OrderID=10404 Total=1591.25
CustomerID=MAGAA OrderID=10467 Total=235.20
CustomerID=MAGAA OrderID=10635 Total=1326.22
CustomerID=MAGAA OrderID=10754 Total=55.20
CustomerID=MAGAA OrderID=10784 Total=1488.00
CustomerID=MAGAA OrderID=10818 Total=833.00
CustomerID=MAGAA OrderID=10939 Total=637.50
CustomerID=MAGAA OrderID=10950 Total=110.00
CustomerID=MAISD OrderID=10529 Total=946.00
CustomerID=MAISD OrderID=10649 Total=1434.00
CustomerID=MAISD OrderID=10760 Total=2917.00
CustomerID=MAISD OrderID=10892 Total=2090.00
CustomerID=MAISD OrderID=10896 Total=750.50
CustomerID=MAISD OrderID=10978 Total=1303.20
CustomerID=MAISD OrderID=11004 Total=295.38
CustomerID=MEREP OrderID=10332 Total=1786.88
CustomerID=MEREP OrderID=10339 Total=3354.00
CustomerID=MEREP OrderID=10376 Total=399.00
CustomerID=MEREP OrderID=10424 Total=9194.56
CustomerID=MEREP OrderID=10439 Total=1078.00
CustomerID=MEREP OrderID=10505 Total=147.90
CustomerID=MEREP OrderID=10565 Total=639.90
CustomerID=MEREP OrderID=10570 Total=2465.25
CustomerID=MEREP OrderID=10590 Total=1101.00
CustomerID=MEREP OrderID=10605 Total=4109.70
CustomerID=MEREP OrderID=10618 Total=2697.50
CustomerID=MEREP OrderID=10619 Total=1260.00
CustomerID=MEREP OrderID=10724 Total=638.50
CustomerID=MORGK OrderID=10277 Total=1200.80
CustomerID=MORGK OrderID=10575 Total=2147.40
CustomerID=MORGK OrderID=10699 Total=114.00
CustomerID=MORGK OrderID=10779 Total=1335.00
CustomerID=MORGK OrderID=10945 Total=245.00
CustomerID=NORTS OrderID=10517 Total=352.00
CustomerID=NORTS OrderID=10752 Total=252.00
CustomerID=NORTS OrderID=11057 Total=45.00
CustomerID=OCEAN OrderID=10409 Total=319.20
CustomerID=OCEAN OrderID=10531 Total=110.00
CustomerID=OCEAN OrderID=10898 Total=30.00
CustomerID=OCEAN OrderID=10958 Total=781.00
CustomerID=OCEAN OrderID=10986 Total=2220.00
CustomerID=OLDWO OrderID=10260 Total=1504.65
CustomerID=OLDWO OrderID=10305 Total=3741.30
CustomerID=OLDWO OrderID=10338 Total=934.50
CustomerID=OLDWO OrderID=10441 Total=1755.00
CustomerID=OLDWO OrderID=10594 Total=565.50
CustomerID=OLDWO OrderID=10680 Total=1261.88
CustomerID=OLDWO OrderID=10706 Total=1893.00
CustomerID=OLDWO OrderID=10855 Total=2227.89
CustomerID=OLDWO OrderID=10965 Total=848.00
CustomerID=OLDWO OrderID=11034 Total=539.40
CustomerID=OTTIK OrderID=10407 Total=1194.00
CustomerID=OTTIK OrderID=10508 Total=240.00
CustomerID=OTTIK OrderID=10554 Total=1728.52
CustomerID=OTTIK OrderID=10580 Total=1013.74
CustomerID=OTTIK OrderID=10684 Total=1768.00
CustomerID=OTTIK OrderID=10766 Total=2310.00
CustomerID=OTTIK OrderID=10833 Total=906.93
CustomerID=OTTIK OrderID=10999 Total=1197.95
CustomerID=OTTIK OrderID=11020 Total=632.40
CustomerID=PERIC OrderID=10322 Total=112.00
CustomerID=PERIC OrderID=10354 Total=568.80
CustomerID=PERIC OrderID=10474 Total=1249.10
CustomerID=PERIC OrderID=10502 Total=816.30
CustomerID=PERIC OrderID=10995 Total=1196.00
CustomerID=PERIC OrderID=11073 Total=300.00
CustomerID=PICCO OrderID=10353 Total=8593.28
CustomerID=PICCO OrderID=10392 Total=1440.00
CustomerID=PICCO OrderID=10427 Total=651.00
CustomerID=PICCO OrderID=10489 Total=439.20
CustomerID=PICCO OrderID=10530 Total=4180.00
CustomerID=PICCO OrderID=10597 Total=718.08
CustomerID=PICCO OrderID=10686 Total=1404.45
CustomerID=PICCO OrderID=10747 Total=1912.85
CustomerID=PICCO OrderID=10844 Total=735.00
CustomerID=PICCO OrderID=11053 Total=3055.00
CustomerID=PRINI OrderID=10336 Total=285.12
CustomerID=PRINI OrderID=10397 Total=716.72
CustomerID=PRINI OrderID=10433 Total=851.20
CustomerID=PRINI OrderID=10477 Total=558.00
CustomerID=PRINI OrderID=10808 Total=1411.00
CustomerID=PRINI OrderID=11007 Total=2633.90
CustomerID=QUEDE OrderID=10261 Total=448.00
CustomerID=QUEDE OrderID=10291 Total=497.52
CustomerID=QUEDE OrderID=10379 Total=863.28
CustomerID=QUEDE OrderID=10421 Total=1194.27
CustomerID=QUEDE OrderID=10587 Total=807.38
CustomerID=QUEDE OrderID=10647 Total=636.00
CustomerID=QUEDE OrderID=10720 Total=550.00
CustomerID=QUEDE OrderID=10794 Total=314.76
CustomerID=QUEDE OrderID=10989 Total=1353.60
CustomerID=QUEEN OrderID=10372 Total=9210.90
CustomerID=QUEEN OrderID=10406 Total=1830.78
CustomerID=QUEEN OrderID=10487 Total=889.70
CustomerID=QUEEN OrderID=10637 Total=2761.94
CustomerID=QUEEN OrderID=10659 Total=1227.02
CustomerID=QUEEN OrderID=10704 Total=595.50
CustomerID=QUEEN OrderID=10728 Total=1296.75
CustomerID=QUEEN OrderID=10786 Total=1531.08
CustomerID=QUEEN OrderID=10868 Total=1920.60
CustomerID=QUEEN OrderID=10913 Total=768.75
CustomerID=QUEEN OrderID=10914 Total=537.50
CustomerID=QUEEN OrderID=10961 Total=1119.90
CustomerID=QUEEN OrderID=11068 Total=2027.08
CustomerID=QUICK OrderID=10273 Total=2037.28
CustomerID=QUICK OrderID=10285 Total=1743.36
CustomerID=QUICK OrderID=10286 Total=3016.00
CustomerID=QUICK OrderID=10313 Total=182.40
CustomerID=QUICK OrderID=10345 Total=2924.80
CustomerID=QUICK OrderID=10361 Total=2046.24
CustomerID=QUICK OrderID=10418 Total=1814.80
CustomerID=QUICK OrderID=10451 Total=3849.66
CustomerID=QUICK OrderID=10515 Total=9921.30
CustomerID=QUICK OrderID=10527 Total=1503.00
CustomerID=QUICK OrderID=10540 Total=10191.70
CustomerID=QUICK OrderID=10549 Total=3554.28
CustomerID=QUICK OrderID=10588 Total=3120.00
CustomerID=QUICK OrderID=10658 Total=4464.60
CustomerID=QUICK OrderID=10691 Total=10164.80
CustomerID=QUICK OrderID=10694 Total=4825.00
CustomerID=QUICK OrderID=10721 Total=923.88
CustomerID=QUICK OrderID=10745 Total=4529.80
CustomerID=QUICK OrderID=10765 Total=1515.60
CustomerID=QUICK OrderID=10788 Total=731.50
CustomerID=QUICK OrderID=10845 Total=3812.70
CustomerID=QUICK OrderID=10865 Total=16387.50
CustomerID=QUICK OrderID=10878 Total=1539.00
CustomerID=QUICK OrderID=10938 Total=2731.88
CustomerID=QUICK OrderID=10962 Total=3584.00
CustomerID=QUICK OrderID=10991 Total=2296.00
CustomerID=QUICK OrderID=10996 Total=560.00
CustomerID=QUICK OrderID=11021 Total=6306.24
CustomerID=RANCH OrderID=10448 Total=443.40
CustomerID=RANCH OrderID=10716 Total=706.00
CustomerID=RANCH OrderID=10828 Total=932.00
CustomerID=RANCH OrderID=10916 Total=686.70
CustomerID=RANCH OrderID=11019 Total=76.00
CustomerID=RATTC OrderID=10262 Total=584.00
CustomerID=RATTC OrderID=10272 Total=1456.00
CustomerID=RATTC OrderID=10294 Total=1887.60
CustomerID=RATTC OrderID=10314 Total=2094.30
CustomerID=RATTC OrderID=10316 Total=2835.00
CustomerID=RATTC OrderID=10346 Total=1618.88
CustomerID=RATTC OrderID=10401 Total=3868.60
CustomerID=RATTC OrderID=10479 Total=10495.60
CustomerID=RATTC OrderID=10564 Total=1234.05
CustomerID=RATTC OrderID=10569 Total=890.00
CustomerID=RATTC OrderID=10598 Total=2388.50
CustomerID=RATTC OrderID=10761 Total=507.00
CustomerID=RATTC OrderID=10820 Total=1140.00
CustomerID=RATTC OrderID=10852 Total=2984.00
CustomerID=RATTC OrderID=10889 Total=11380.00
CustomerID=RATTC OrderID=10988 Total=3574.80
CustomerID=RATTC OrderID=11000 Total=903.75
CustomerID=RATTC OrderID=11077 Total=1255.72
CustomerID=REGGC OrderID=10288 Total=80.10
CustomerID=REGGC OrderID=10428 Total=192.00
CustomerID=REGGC OrderID=10443 Total=517.44
CustomerID=REGGC OrderID=10562 Total=488.70
CustomerID=REGGC OrderID=10586 Total=23.80
CustomerID=REGGC OrderID=10655 Total=154.40
CustomerID=REGGC OrderID=10727 Total=1624.50
CustomerID=REGGC OrderID=10812 Total=1692.80
CustomerID=REGGC OrderID=10908 Total=663.10
CustomerID=REGGC OrderID=10942 Total=560.00
CustomerID=REGGC OrderID=11010 Total=645.00
CustomerID=REGGC OrderID=11062 Total=406.40
CustomerID=RICAR OrderID=10287 Total=819.00
CustomerID=RICAR OrderID=10299 Total=349.50
CustomerID=RICAR OrderID=10447 Total=914.40
CustomerID=RICAR OrderID=10481 Total=1472.00
CustomerID=RICAR OrderID=10563 Total=965.00
CustomerID=RICAR OrderID=10622 Total=560.00
CustomerID=RICAR OrderID=10648 Total=372.38
CustomerID=RICAR OrderID=10813 Total=602.40
CustomerID=RICAR OrderID=10851 Total=2603.00
CustomerID=RICAR OrderID=10877 Total=1955.12
CustomerID=RICAR OrderID=11059 Total=1838.00
CustomerID=RICSU OrderID=10255 Total=2490.50
CustomerID=RICSU OrderID=10419 Total=2097.60
CustomerID=RICSU OrderID=10537 Total=1823.80
CustomerID=RICSU OrderID=10666 Total=4666.94
CustomerID=RICSU OrderID=10751 Total=1631.48
CustomerID=RICSU OrderID=10758 Total=1644.60
CustomerID=RICSU OrderID=10931 Total=799.20
CustomerID=RICSU OrderID=10951 Total=458.76
CustomerID=RICSU OrderID=11033 Total=3232.80
CustomerID=RICSU OrderID=11075 Total=498.10
CustomerID=ROMEY OrderID=10281 Total=86.50
CustomerID=ROMEY OrderID=10282 Total=155.40
CustomerID=ROMEY OrderID=10306 Total=498.50
CustomerID=ROMEY OrderID=10917 Total=365.89
CustomerID=ROMEY OrderID=11013 Total=361.00
CustomerID=SANTG OrderID=10387 Total=1058.40
CustomerID=SANTG OrderID=10520 Total=200.00
CustomerID=SANTG OrderID=10639 Total=500.00
CustomerID=SANTG OrderID=10831 Total=2684.40
CustomerID=SANTG OrderID=10909 Total=670.00
CustomerID=SANTG OrderID=11015 Total=622.35
CustomerID=SAVEA OrderID=10324 Total=5275.72
CustomerID=SAVEA OrderID=10393 Total=2556.95
CustomerID=SAVEA OrderID=10398 Total=2505.60
CustomerID=SAVEA OrderID=10440 Total=4924.14
CustomerID=SAVEA OrderID=10452 Total=2018.50
CustomerID=SAVEA OrderID=10510 Total=4707.54
CustomerID=SAVEA OrderID=10555 Total=2944.40
CustomerID=SAVEA OrderID=10603 Total=1483.00
CustomerID=SAVEA OrderID=10607 Total=6475.40
CustomerID=SAVEA OrderID=10612 Total=6375.00
CustomerID=SAVEA OrderID=10627 Total=1185.75
CustomerID=SAVEA OrderID=10657 Total=4371.60
CustomerID=SAVEA OrderID=10678 Total=5256.50
CustomerID=SAVEA OrderID=10700 Total=1638.40
CustomerID=SAVEA OrderID=10711 Total=4451.70
CustomerID=SAVEA OrderID=10713 Total=2827.90
CustomerID=SAVEA OrderID=10714 Total=2205.75
CustomerID=SAVEA OrderID=10722 Total=1570.00
CustomerID=SAVEA OrderID=10748 Total=2196.00
CustomerID=SAVEA OrderID=10757 Total=3082.00
CustomerID=SAVEA OrderID=10815 Total=40.00
CustomerID=SAVEA OrderID=10847 Total=4931.92
CustomerID=SAVEA OrderID=10882 Total=892.64
CustomerID=SAVEA OrderID=10894 Total=2753.10
CustomerID=SAVEA OrderID=10941 Total=4011.75
CustomerID=SAVEA OrderID=10983 Total=720.90
CustomerID=SAVEA OrderID=10984 Total=1809.75
CustomerID=SAVEA OrderID=11002 Total=1811.10
CustomerID=SAVEA OrderID=11030 Total=12615.05
CustomerID=SAVEA OrderID=11031 Total=2393.50
CustomerID=SAVEA OrderID=11064 Total=4330.40
CustomerID=SEVES OrderID=10359 Total=3471.68
CustomerID=SEVES OrderID=10377 Total=863.60
CustomerID=SEVES OrderID=10388 Total=1228.80
CustomerID=SEVES OrderID=10472 Total=1036.80
CustomerID=SEVES OrderID=10523 Total=2444.31
CustomerID=SEVES OrderID=10547 Total=1792.80
CustomerID=SEVES OrderID=10800 Total=1468.94
CustomerID=SEVES OrderID=10804 Total=2278.40
CustomerID=SEVES OrderID=10869 Total=1630.00
CustomerID=SIMOB OrderID=10341 Total=352.60
CustomerID=SIMOB OrderID=10417 Total=11188.40
CustomerID=SIMOB OrderID=10556 Total=835.20
CustomerID=SIMOB OrderID=10642 Total=696.00
CustomerID=SIMOB OrderID=10669 Total=570.00
CustomerID=SIMOB OrderID=10802 Total=2942.81
CustomerID=SIMOB OrderID=11074 Total=232.08
CustomerID=SPECD OrderID=10738 Total=52.35
CustomerID=SPECD OrderID=10907 Total=108.50
CustomerID=SPECD OrderID=10964 Total=2052.50
CustomerID=SPECD OrderID=11043 Total=210.00
CustomerID=SPLIR OrderID=10271 Total=48.00
CustomerID=SPLIR OrderID=10329 Total=4578.43
CustomerID=SPLIR OrderID=10349 Total=141.60
CustomerID=SPLIR OrderID=10369 Total=2390.40
CustomerID=SPLIR OrderID=10385 Total=691.20
CustomerID=SPLIR OrderID=10432 Total=485.00
CustomerID=SPLIR OrderID=10756 Total=1990.00
CustomerID=SPLIR OrderID=10821 Total=678.00
CustomerID=SPLIR OrderID=10974 Total=439.00
CustomerID=SUPRD OrderID=10252 Total=3597.90
CustomerID=SUPRD OrderID=10302 Total=2708.80
CustomerID=SUPRD OrderID=10458 Total=3891.00
CustomerID=SUPRD OrderID=10463 Total=713.30
CustomerID=SUPRD OrderID=10475 Total=1505.18
CustomerID=SUPRD OrderID=10767 Total=28.00
CustomerID=SUPRD OrderID=10841 Total=4581.00
CustomerID=SUPRD OrderID=10846 Total=1112.00
CustomerID=SUPRD OrderID=10885 Total=1209.00
CustomerID=SUPRD OrderID=10930 Total=2255.50
CustomerID=SUPRD OrderID=11035 Total=1754.50
CustomerID=SUPRD OrderID=11038 Total=732.60
CustomerID=THEBI OrderID=10310 Total=336.00
CustomerID=THEBI OrderID=10708 Total=180.40
CustomerID=THEBI OrderID=10805 Total=2775.00
CustomerID=THEBI OrderID=10992 Total=69.60
CustomerID=THECR OrderID=10624 Total=1393.24
CustomerID=THECR OrderID=10775 Total=228.00
CustomerID=THECR OrderID=11003 Total=326.00
CustomerID=TOMSP OrderID=10438 Total=454.00
CustomerID=TOMSP OrderID=10446 Total=246.24
CustomerID=TOMSP OrderID=10548 Total=240.10
CustomerID=TOMSP OrderID=10608 Total=1064.00
CustomerID=TOMSP OrderID=10967 Total=910.40
CustomerID=TORTU OrderID=10276 Total=420.00
CustomerID=TORTU OrderID=10293 Total=848.70
CustomerID=TORTU OrderID=10304 Total=954.40
CustomerID=TORTU OrderID=10319 Total=1191.20
CustomerID=TORTU OrderID=10518 Total=4150.05
CustomerID=TORTU OrderID=10576 Total=838.45
CustomerID=TORTU OrderID=10676 Total=534.85
CustomerID=TORTU OrderID=10842 Total=975.00
CustomerID=TORTU OrderID=10915 Total=539.50
CustomerID=TORTU OrderID=11069 Total=360.00
CustomerID=TRADH OrderID=10249 Total=1863.40
CustomerID=TRADH OrderID=10292 Total=1296.00
CustomerID=TRADH OrderID=10496 Total=190.00
CustomerID=TRADH OrderID=10606 Total=1130.40
CustomerID=TRADH OrderID=10830 Total=1974.00
CustomerID=TRADH OrderID=10834 Total=1432.71
CustomerID=TRADH OrderID=10839 Total=827.55
CustomerID=TRAIH OrderID=10574 Total=764.30
CustomerID=TRAIH OrderID=10577 Total=569.00
CustomerID=TRAIH OrderID=10822 Total=237.90
CustomerID=VAFFE OrderID=10367 Total=834.20
CustomerID=VAFFE OrderID=10399 Total=1765.60
CustomerID=VAFFE OrderID=10465 Total=2518.00
CustomerID=VAFFE OrderID=10591 Total=812.50
CustomerID=VAFFE OrderID=10602 Total=48.75
CustomerID=VAFFE OrderID=10688 Total=3160.60
CustomerID=VAFFE OrderID=10744 Total=736.00
CustomerID=VAFFE OrderID=10769 Total=1684.28
CustomerID=VAFFE OrderID=10921 Total=1936.00
CustomerID=VAFFE OrderID=10946 Total=1407.50
CustomerID=VAFFE OrderID=10994 Total=940.50
CustomerID=VICTE OrderID=10251 Total=654.06
CustomerID=VICTE OrderID=10334 Total=144.80
CustomerID=VICTE OrderID=10450 Total=425.12
CustomerID=VICTE OrderID=10459 Total=1659.20
CustomerID=VICTE OrderID=10478 Total=471.20
CustomerID=VICTE OrderID=10546 Total=2812.00
CustomerID=VICTE OrderID=10806 Total=439.60
CustomerID=VICTE OrderID=10814 Total=1788.45
CustomerID=VICTE OrderID=10843 Total=159.00
CustomerID=VICTE OrderID=10850 Total=629.00
CustomerID=VINET OrderID=10274 Total=538.60
CustomerID=VINET OrderID=10295 Total=121.60
CustomerID=VINET OrderID=10737 Total=139.80
CustomerID=VINET OrderID=10739 Total=240.00
CustomerID=WANDK OrderID=10301 Total=755.00
CustomerID=WANDK OrderID=10312 Total=1614.80
CustomerID=WANDK OrderID=10348 Total=363.60
CustomerID=WANDK OrderID=10356 Total=1106.40
CustomerID=WANDK OrderID=10513 Total=1942.00
CustomerID=WANDK OrderID=10632 Total=589.00
CustomerID=WANDK OrderID=10640 Total=708.75
CustomerID=WANDK OrderID=10651 Total=397.80
CustomerID=WANDK OrderID=10668 Total=625.28
CustomerID=WANDK OrderID=11046 Total=1485.80
CustomerID=WARTH OrderID=10266 Total=346.56
CustomerID=WARTH OrderID=10270 Total=1376.00
CustomerID=WARTH OrderID=10320 Total=516.00
CustomerID=WARTH OrderID=10333 Total=877.20
CustomerID=WARTH OrderID=10412 Total=334.80
CustomerID=WARTH OrderID=10416 Total=720.00
CustomerID=WARTH OrderID=10437 Total=393.00
CustomerID=WARTH OrderID=10455 Total=2684.00
CustomerID=WARTH OrderID=10526 Total=1151.40
CustomerID=WARTH OrderID=10553 Total=1546.30
CustomerID=WARTH OrderID=10583 Total=2237.50
CustomerID=WARTH OrderID=10636 Total=629.50
CustomerID=WARTH OrderID=10750 Total=1590.56
CustomerID=WARTH OrderID=10781 Total=975.88
CustomerID=WARTH OrderID=11025 Total=270.00
CustomerID=WELLI OrderID=10256 Total=517.80
CustomerID=WELLI OrderID=10420 Total=1707.84
CustomerID=WELLI OrderID=10585 Total=142.50
CustomerID=WELLI OrderID=10644 Total=1371.80
CustomerID=WELLI OrderID=10803 Total=1193.01
CustomerID=WELLI OrderID=10809 Total=140.00
CustomerID=WELLI OrderID=10900 Total=33.75
CustomerID=WELLI OrderID=10905 Total=342.00
CustomerID=WELLI OrderID=10935 Total=619.50
CustomerID=WHITC OrderID=10269 Total=642.20
CustomerID=WHITC OrderID=10344 Total=2296.00
CustomerID=WHITC OrderID=10469 Total=956.68
CustomerID=WHITC OrderID=10483 Total=668.80
CustomerID=WHITC OrderID=10504 Total=1388.50
CustomerID=WHITC OrderID=10596 Total=1180.88
CustomerID=WHITC OrderID=10693 Total=2071.20
CustomerID=WHITC OrderID=10696 Total=996.00
CustomerID=WHITC OrderID=10723 Total=468.45
CustomerID=WHITC OrderID=10740 Total=1416.00
CustomerID=WHITC OrderID=10861 Total=3523.40
CustomerID=WHITC OrderID=10904 Total=1924.25
CustomerID=WHITC OrderID=11032 Total=8902.50
CustomerID=WHITC OrderID=11066 Total=928.75
CustomerID=WILMK OrderID=10248 Total=440.00
CustomerID=WILMK OrderID=10615 Total=120.00
CustomerID=WILMK OrderID=10673 Total=412.35
CustomerID=WILMK OrderID=10695 Total=642.00
CustomerID=WILMK OrderID=10873 Total=336.80
CustomerID=WILMK OrderID=10879 Total=611.30
CustomerID=WILMK OrderID=10910 Total=452.90
CustomerID=WILMK OrderID=11005 Total=586.00
CustomerID=WOLZA OrderID=10374 Total=459.00
CustomerID=WOLZA OrderID=10611 Total=808.00
CustomerID=WOLZA OrderID=10792 Total=399.85
CustomerID=WOLZA OrderID=10870 Total=160.00
CustomerID=WOLZA OrderID=10906 Total=427.50
CustomerID=WOLZA OrderID=10998 Total=686.00
CustomerID=WOLZA OrderID=11044 Total=591.60
Group Join
Simple group join
Public Sub DataSetLinq120()
Dim customers = TestDS.Tables("Customers").AsEnumerable()
Dim orders = TestDS.Tables("Orders").AsEnumerable()
Dim q = From c In customers _
Group Join o In orders On c("CustomerID") Equals o("CustomerID") Into Count() _
Select CustomerID = c("CustomerID"), ords = Count
For Each r In q
Console.WriteLine("CustomerID: {0} Orders Count: {1}", r.CustomerID, r.ords)
Next
End Sub
Result:
CustomerID: ALFKI Orders Count: 6
CustomerID: ANATR Orders Count: 4
CustomerID: ANTON Orders Count: 7
CustomerID: AROUT Orders Count: 13
CustomerID: BERGS Orders Count: 18
CustomerID: BLAUS Orders Count: 7
CustomerID: BLONP Orders Count: 11
CustomerID: BOLID Orders Count: 3
CustomerID: BONAP Orders Count: 17
CustomerID: BOTTM Orders Count: 14
CustomerID: BSBEV Orders Count: 10
CustomerID: CACTU Orders Count: 6
CustomerID: CENTC Orders Count: 1
CustomerID: CHOPS Orders Count: 8
CustomerID: COMMI Orders Count: 5
CustomerID: CONSH Orders Count: 3
CustomerID: DRACD Orders Count: 6
CustomerID: DUMON Orders Count: 4
CustomerID: EASTC Orders Count: 8
CustomerID: ERNSH Orders Count: 30
CustomerID: FAMIA Orders Count: 7
CustomerID: FISSA Orders Count: 0
CustomerID: FOLIG Orders Count: 5
CustomerID: FOLKO Orders Count: 19
CustomerID: FRANK Orders Count: 15
CustomerID: FRANR Orders Count: 3
CustomerID: FRANS Orders Count: 6
CustomerID: FURIB Orders Count: 8
CustomerID: GALED Orders Count: 5
CustomerID: GODOS Orders Count: 10
CustomerID: GOURL Orders Count: 9
CustomerID: GREAL Orders Count: 11
CustomerID: GROSR Orders Count: 2
CustomerID: HANAR Orders Count: 14
CustomerID: HILAA Orders Count: 18
CustomerID: HUNGC Orders Count: 5
CustomerID: HUNGO Orders Count: 19
CustomerID: ISLAT Orders Count: 10
CustomerID: KOENE Orders Count: 14
CustomerID: LACOR Orders Count: 4
CustomerID: LAMAI Orders Count: 14
CustomerID: LAUGB Orders Count: 3
CustomerID: LAZYK Orders Count: 2
CustomerID: LEHMS Orders Count: 15
CustomerID: LETSS Orders Count: 4
CustomerID: LILAS Orders Count: 14
CustomerID: LINOD Orders Count: 12
CustomerID: LONEP Orders Count: 8
CustomerID: MAGAA Orders Count: 10
CustomerID: MAISD Orders Count: 7
CustomerID: MEREP Orders Count: 13
CustomerID: MORGK Orders Count: 5
CustomerID: NORTS Orders Count: 3
CustomerID: OCEAN Orders Count: 5
CustomerID: OLDWO Orders Count: 10
CustomerID: OTTIK Orders Count: 9
CustomerID: PARIS Orders Count: 0
CustomerID: PERIC Orders Count: 6
CustomerID: PICCO Orders Count: 10
CustomerID: PRINI Orders Count: 6
CustomerID: QUEDE Orders Count: 9
CustomerID: QUEEN Orders Count: 13
CustomerID: QUICK Orders Count: 28
CustomerID: RANCH Orders Count: 5
CustomerID: RATTC Orders Count: 18
CustomerID: REGGC Orders Count: 12
CustomerID: RICAR Orders Count: 11
CustomerID: RICSU Orders Count: 10
CustomerID: ROMEY Orders Count: 5
CustomerID: SANTG Orders Count: 6
CustomerID: SAVEA Orders Count: 31
CustomerID: SEVES Orders Count: 9
CustomerID: SIMOB Orders Count: 7
CustomerID: SPECD Orders Count: 4
CustomerID: SPLIR Orders Count: 9
CustomerID: SUPRD Orders Count: 12
CustomerID: THEBI Orders Count: 4
CustomerID: THECR Orders Count: 3
CustomerID: TOMSP Orders Count: 5
CustomerID: TORTU Orders Count: 10
CustomerID: TRADH Orders Count: 7
CustomerID: TRAIH Orders Count: 3
CustomerID: VAFFE Orders Count: 11
CustomerID: VICTE Orders Count: 10
CustomerID: VINET Orders Count: 4
CustomerID: WANDK Orders Count: 10
CustomerID: WARTH Orders Count: 15
CustomerID: WELLI Orders Count: 9
CustomerID: WHITC Orders Count: 14
CustomerID: WILMK Orders Count: 8
CustomerID: WOLZA Orders Count: 7
