English 中文(简体)
试图加入四个表格, 不断给我多个结果, 但每个选择的语句都给出我想要的东西
原标题：Trying to join four tables keeps giving me multiple results but each select statement gives what I want

我有两个问题:

  1. SELECT     
    CondoFeed2.regionCode, CondoFeed2_Resorts.Resort, CondoFeed2_Resorts.Location,  
    CondoFeed2_Resorts.CheckIn, CondoFeed2_Resorts.[Bed Rooms]
FROM         
    CondoFeed2_Show_All_Resorts 
INNER JOIN
    CondoFeed2 ON CondoFeed2_Show_All_Resorts.[CondoFeed2 ID] = CondoFeed2.[CondoFeed2 ID] 
INNER JOIN
    CondoFeed2_Resorts ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_Resorts.[Show All Resorts ID]

  2. SELECT     
    CondoFeed2_More_Info.[front page image]
FROM         
    [VWR EXPORT CondoFeed] 
INNER JOIN
    CondoFeed2_Show_All_Resorts ON [VWR EXPORT CondoFeed].[CondoFeed ID] = CondoFeed2_Show_All_Resorts.[CondoFeed2 ID] 
RIGHT OUTER JOIN
    CondoFeed2_More_Info ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_More_Info.[Show All Resorts ID]

其结果如下:

regionCode  Resort                                                Location                                   CheckIn       Bed Rooms
----------  ----------------------------------------------------  -----------------------------------------  ------------  ---------
FLNE        Plantation Isl和                                     Ormond Beach, FL                           Sep 15, 2012  1
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 8, 2012   Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 15, 2012  Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 29, 2012  Studio
FLNE        Vacation Villas                                       Titusville, FL                             Sep 29, 2012  2
FLNE        Silver Beach Club Resort Condo                        Daytona Beach, FL                          Sep 22, 2012  Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 28, 2012  Studio
FLNE        Outrigger Beach Club                                  Ormond Beach, FL                           Sep 8, 2012   Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 7, 2012   Studio
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 15, 2012  Studio
FLNE        Outrigger Beach Club                                  Ormond Beach, FL                           Sep 8, 2012   Hotel
FLNE        Ocean East Resort Club                                Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 8, 2012   Studio
FLNE        S和 和 Surf Condominium                             Daytona Beach Shores, FL                   Sep 8, 2012   1
FLNE        Gr和 Lakefront Resort Club Usa / Holly Bluff Marina  Del和, FL                                 Sep 9, 2012   2
FLNE        Dolphin Beach Club                                    Daytona Beach Shores, FL                   Sep 15, 2012  Studio
FLNE        Silver Beach Club Resort Condo                        Daytona Beach, FL                          Sep 29, 2012  Studio
FLNE        Gr和 Lakefront Resort Club Usa / Holly Bluff Marina  Del和, FL                                 Sep 1, 2012   2
FLNE        Dolphin Beach Club                                    Daytona Beach Shores, FL                   Sep 29, 2012  Studio
FLNE        Vacation Villas                                       Titusville, FL                             Sep 21, 2012  1
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Dolphin Beach Club                                    Daytona Beach Shores, FL                   Sep 29, 2012  Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 8, 2012   Studio
FLNE        Vacation Villas                                       Titusville, FL                             Sep 8, 2012   2
FLNE        Plantation Isl和                                     Ormond Beach, FL                           Sep 8, 2012   1
FLNE        Vacation Villas                                       Titusville, FL                             Sep 1, 2012   2
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 29, 2012  1
FLNE        Gr和 Lakefront Resort                                Club Usa / Holly Bluff Marina  Del和, FL  Sep 29, 2012  2
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 15, 2012  Studio
FLNE        Dolphin Beach Club                                    Daytona Beach Shores, FL                   Sep 22, 2012  Studio
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 29, 2012  Studio
FLNE        Outrigger Beach Club                                  Ormond Beach, FL                           Sep 15, 2012  Hotel
FLNE        S和 和 Surf Condominium                             Daytona Beach Shores, FL                   Sep 29, 2012  1
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 21, 2012  Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 14, 2012  Studio
FLNE        Ocean East Resort Club                                Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Traders Inn Beach Club                                Ormond Beach, FL                           Sep 29, 2012  Studio
FLNE        Vacation Villas                                       Titusville, FL                             Sep 29, 2012  1
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Sea Club Iv                                           Daytona Beach Shores, FL                   Sep 8, 2012   Studio
FLNE        Fantasy Isl和 Resort                                 Daytona Beach Shores, FL                   Sep 15, 2012  1
FLNE        Plantation Isl和                                     Ormond Beach, FL                           Sep 21, 2012  1
FLNE        Sea Club Iv                                           Daytona Beach Shores, FL                   Sep 22, 2012  Studio
FLNE        Ocean East Resort Club                                Ormond Beach, FL                           Sep 29, 2012  Studio
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 29, 2012  Studio
FLNE        Isl和er Beach Resort                                 New Smyrna Beach, FL                       Sep 22, 2012  Studio
FLNE        Turtle Inn                                            Daytona Beach Shores, FL                   Sep 15, 2012  Studio
FLNE        Vacation Villas                                       Titusville, FL                             Sep 22, 2012  1
FLNE        Dolphin Beach Club                                    Daytona Beach Shores, FL                   Sep 8, 2012   Studio
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Outrigger Beach Club                                  Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Outrigger Beach Club                                  Ormond Beach, FL                           Sep 22, 2012  Hotel
FLNE        Gr和 Lakefront Resort Club Usa / Holly Bluff Marina  Del和, FL                                 Sep 16, 2012  2
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 15, 2012  Studio
FLNE        Fantasy Isl和 Resort                                 Daytona Beach Shores, FL                   Sep 8, 2012   Studio
FLNE        Ocean East Resort Club                                Ormond Beach, FL                           Sep 15, 2012  Studio
FLNE        Georgian Inn Beach Club                               Ormond Beach, FL                           Sep 22, 2012  Studio
FLNE        Ocean East Resort Club                                Ormond Beach, FL                           Sep 8, 2012   Studio
FLNE        Turtle Inn                                            Daytona Beach Shores, FL                   Sep 29, 2012  Studio
FLNE        Club Sea Oats                                         Daytona Beach Shores, FL                   Sep 15, 2012  1
FLNE        Gr和 Lakefront Resort Club Usa / Holly Bluff Marina  Del和, FL                                 Sep 23, 2012  2

和

front page image
---------------------------------------------------------------------------------------------------------------
C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filesa7b45df4501c4f899bc4c5b60f357ae0.jpg
NULL





C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filescaecc59b0f5947c8a98f9f44680d551b.jpg

C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files6f6465af11fa49338d564ed22de1e97a.jpg

NULL





C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filesc76295564f1943bebb66e887ccefc144.jpg



C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files14a99384744c44b49acbf9b3dd8aa91d.jpg
C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files9e2dcd00ab0a403585a7a199e8c82f09.jpg
NULL
C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files4d54041b95d64625894ec4910699d55b.jpg

C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files8625205756c94603a5931065f6f76831.jpg

NULL



C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files3842b7c651b406ab2fb2d3df0d62481.jpg

两者分别。

下列查询产生单一结果,但产生重复:

SELECT     CondoFeed2_Resorts.[Bed Rooms], CondoFeed2_Resorts.CheckIn, CondoFeed2_Resorts.Location, CondoFeed2_Resorts.Resort, CondoFeed2.regionCode, 
                      CondoFeed2_More_Info.[front page image]
FROM         CondoFeed2_Show_All_Resorts INNER JOIN
                      CondoFeed2_Resorts ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_Resorts.[Show All Resorts ID] INNER JOIN
                      CondoFeed2_More_Info ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_More_Info.[Show All Resorts ID] INNER JOIN
                      CondoFeed2 ON CondoFeed2_Show_All_Resorts.[CondoFeed2 ID] = CondoFeed2.[CondoFeed2 ID]

此产量 :

Bed Rooms  CheckIn       Location  Resort      regionCode                 front page image
---------  ------------  --------  ----------  -------------------------  ---------------------------------------------------------------------------------------------------------------------
Hotel      May 11, 2013  ACAPULCO, GRO MEXICO  Hotel & Club Aladino s     ACAP  
Hotel      May 11, 2013  ACAPULCO, GRO MEXICO  Hotel & Club Aladino s     ACAP  
Hotel      May 4, 2013   ACAPULCO, GRO MEXICO  Hotel & Club Aladino s     ACAP  
Hotel      May 4, 2013   ACAPULCO, GRO MEXICO  Hotel & Club Aladino s     ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filese06d05f720d344acaafec5d776694301.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filesf594d4ee4acc4e6387ac425e6c30ca48.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files59064e6e752d443e89b271b166ab87b9.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files6cdb76a4733c46e2ac2361eda6829861.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files995d8616aa3f4c85a5dd7c365276e113.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files69d05f9cd02e4bd0af5525129116f9a5.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files15293494d88a4d19b25a87d9ab294261.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files391fdb43e1f4aef85ef2cb8800e2db6.jpg
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
1          Sep 23, 2012  Acapulco, GRO MEXICO  Mayan Sea Garden Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filese06d05f720d344acaafec5d776694301.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filesf594d4ee4acc4e6387ac425e6c30ca48.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files59064e6e752d443e89b271b166ab87b9.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files6cdb76a4733c46e2ac2361eda6829861.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files995d8616aa3f4c85a5dd7c365276e113.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files69d05f9cd02e4bd0af5525129116f9a5.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files15293494d88a4d19b25a87d9ab294261.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files391fdb43e1f4aef85ef2cb8800e2db6.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  The Gr和 Mayan Acapulco  ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filese06d05f720d344acaafec5d776694301.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Filesf594d4ee4acc4e6387ac425e6c30ca48.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files59064e6e752d443e89b271b166ab87b9.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  C:UsersAdministratorDocumentsVisual Web RipperOutputCondoFeed2Files6cdb76a4733c46e2ac2361eda6829861.jpg
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP  
Hotel      Sep 2, 2012  Acapulco, GRO MEXICO  Club Vacacional Tortuga   ACAP
问题回答

“合并说明”省略了组成查询的部分内容,例如VWR Export CondoFeed 。

以下是我所认为的两个问题“简单的内在结合 ” 。 在不知道你的计划与数据的情况下, 测试由你决定。

SELECT     
    CondoFeed2.regionCode, CondoFeed2_Resorts.Resort, CondoFeed2_Resorts.Location,  
    CondoFeed2_Resorts.CheckIn, CondoFeed2_Resorts.[Bed Rooms],
    CondoFeed2_More_Info.[front page image]
FROM         
    CondoFeed2_Show_All_Resorts 
INNER JOIN
    CondoFeed2 ON CondoFeed2_Show_All_Resorts.[CondoFeed2 ID] = CondoFeed2.[CondoFeed2 ID] 
INNER JOIN
    CondoFeed2_Resorts ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_Resorts.[Show All Resorts ID]
INNER JOIN
    [VWR EXPORT CondoFeed] ON [VWR EXPORT CondoFeed].[CondoFeed ID] = CondoFeed2_Show_All_Resorts.[CondoFeed2 ID] 
RIGHT OUTER JOIN
    CondoFeed2_More_Info ON CondoFeed2_Show_All_Resorts.[Show All Resorts ID] = CondoFeed2_More_Info.[Show All Resorts ID]

我并不明显为什么你的查询给了你重复的行,但省略的 INNER JOIN (在您的情况中确实发生)肯定会给您带来不必要的额外行。

(一般说来,重复行往往也是由不够具体的连结条件造成,使双方“相互乘以”。在像你们这样的案例中,也许有必要检查在连结条件中提及的列是否至少是一个侧面的主键,而不是在组合主键或多栏独有的制约下仅是一列,而不是在组合主键或多栏独有的制约下仅是一列。 最简单的办法是将其他列加到连结条件中。 )

时间：2012-05-22 08:06:51


上一篇：
下一篇：


相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

时间：2009-11-13 05:35:38 回答：3 展示：1
难以执行 REGEXP_SUBSTR

I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域

时间：2009-11-13 04:45:17 回答：1 展示：1
SQL Query Shortcuts

What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2

时间：2009-11-13 04:22:07 回答：3 展示：1
PHP array callback functions for cleaning output

I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...

时间：2009-11-09 15:35:56 回答：5 展示：1
OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

时间：2009-11-09 14:37:41 回答：5 展示：1
Running numbers in SQL

I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...

时间：2009-11-09 14:33:30 回答：3 展示：1
How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

时间：2009-11-09 14:20:51 回答：1 展示：1
热门标签

友情链接

Allggapp Alljchome-教程家园 mvfinale.com-影视剧情大结局大全