SQL Server：如何加入这两个表？

问题描述：

表PRODUCTO：

+-------------+-------------+-------------------------------------------+----------------------+----------+-------+------------+-------+------------------------+----------+-------+-------+-------------------------------------------+----------------------+------------+-------+----------+----------+--------+--------+---------------+----------+------------+------------+---------------+---------------+--------+--------+------------------+---------+---------------+--------+------------+----------+------------+----------+-------------+------------+-------------------+-------------------+ 
| Id_Sucursal | Id_Producto |    Clave_Eq_Sisco    |  Num_Serie  | No_Parte | OEM | Cod_Barras | Marca |   Modelo   | Original | Linea | Nuevo |    Descr_Larga    |  Descr_Corta  | Existencia | Costo | Impuesto | Utilidad | Precio | Oferta | Precio_Oferta | Cantidad | F_Inicio | F_Fin | Precio_Maximo | Precio_Minimo | Maximo | Minimo | Compatibilidades | Estatus | Observaciones | Codigo | F_Alta | Usr_Alta | F_Baja | Usr_Baja | rendimiento | estatus_oc | porcentaje_maximo | porcentaje_minimo | 
+-------------+-------------+-------------------------------------------+----------------------+----------+-------+------------+-------+------------------------+----------+-------+-------+-------------------------------------------+----------------------+------------+-------+----------+----------+--------+--------+---------------+----------+------------+------------+---------------+---------------+--------+--------+------------------+---------+---------------+--------+------------+----------+------------+----------+-------------+------------+-------------------+-------------------+ 
| CORDOBA  |  1219 | TORCSAMSAN0000001219      | 28837    |   | 28837 | 28837  | SAMS |      | A  | TORC | N  | TONER BOTELLA ALTERNO 220G    |      |   43 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 12/03/2013 | 12/03/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 12/03/2013 | COMPRAS | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| TEHUACAN |  1219 | TORCSAMSAN0000001219      | 28837    |   | 28837 | 28837  | SAMS |      | A  | TORC | N  | TONER BOTELLA ALTERNO 220G    |      |   31 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 12/03/2013 | 12/03/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 12/03/2013 | COMPRAS | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| XALAPA  |  1219 | TORCSAMSAN0000001219      | 28837    |   | 28837 | 28837  | SAMS |      | A  | TORC | N  | TONER BOTELLA ALTERNO 220G    |      |   10 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 12/03/2013 | 12/03/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 12/03/2013 | COMPRAS | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| CORDOBA  |   612 | TORCHEPAAN0000000612      | 32385    |   | 32385 | 32385  | HEPA | LASER JET-1012   | A  | TORC | N  | TONER RECARGA GENERICO 100 G HP   |      |   1 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 18/12/2012 | 18/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 18/12/2012 | SUP  | 01/01/1900 |   |   0 |   |     0 |     0 | 
| TEHUACAN |   612 | TORCHEPAAN0000000612      | 32385    |   | 32385 | 32385  | HEPA | LASER JET-1012   | A  | TORC | N  | TONER RECARGA GENERICO 100 G HP   |      |   8 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 18/12/2012 | 18/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 18/12/2012 | SUP  | 01/01/1900 |   |   0 |   |     0 |     0 | 
| XALAPA  |   612 | TORCHEPAAN0000000612      | 32385    |   | 32385 | 32385  | HEPA | LASER JET-1012   | A  | TORC | N  | TONER RECARGA GENERICO 100 G HP   |      |   11 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 18/12/2012 | 18/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 18/12/2012 | SUP  | 01/01/1900 |   |   0 |   |     0 |     0 | 
| CORDOBA  |   717 | TORCKATUAN0000000717      | 37069    | 37069 | 37069 | 37069  | SHAR | AL-2031    | A  | TORC | N  | TONER RECARGA GENERICO 240 G SHARP  |      |   8 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 20/12/2012 | 20/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 20/12/2012 | SUP  | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| TEHUACAN |   717 | TORCKATUAN0000000717      | 37069    | 37069 | 37069 | 37069  | SHAR | AL-2031    | A  | TORC | N  | TONER RECARGA GENERICO 240 G SHARP  |      |   15 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 20/12/2012 | 20/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 20/12/2012 | SUP  | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| XALAPA  |   717 | TORCKATUAN0000000717      | 37069    | 37069 | 37069 | 37069  | SHAR | AL-2031    | A  | TORC | N  | TONER RECARGA GENERICO 240 G SHARP  |      |   11 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 20/12/2012 | 20/12/2012 |    0 |    0 |  0 |  0 |     | A  |    |  | 20/12/2012 | SUP  | 01/01/1900 |   |  5000 |   |     0 |     0 | 
| CORDOBA  |  1023 | TORCKATUAN0000001023      | TK-1147-172--137-162 | 44259 | 44259 | 29458  | KYMI |      | A  | TORC | N  | TONER RECARGA GENERICO 290GR. KYOCERA |      |   19 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 17/01/2013 | 17/01/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 17/01/2013 | SUP  | 01/01/1900 |   |  7000 |   |     0 |     0 | 
| TEHUACAN |  1023 | TORCKATUAN0000001023      | TK-1147-172--137-162 | 44259 | 44259 | 29458  | KYMI |      | A  | TORC | N  | TONER RECARGA GENERICO 290GR. KYOCERA |      |   27 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 17/01/2013 | 17/01/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 17/01/2013 | SUP  | 01/01/1900 |   |  7000 |   |     0 |     0 | 
| XALAPA  |  1023 | TORCKATUAN0000001023      | TK-1147-172--137-162 | 44259 | 44259 | 29458  | KYMI |      | A  | TORC | N  | TONER RECARGA GENERICO 290GR. KYOCERA |      |   18 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 17/01/2013 | 17/01/2013 |    0 |    0 |  0 |  0 |     | A  |    |  | 17/01/2013 | SUP  | 01/01/1900 |   |  7000 |   |     0 |     0 | 
| CORDOBA  |  1803 | TINCHEPADESKJETADVANTAGE-2515ON0000001803 | # 662    | CZ103AL |  | CZ103AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP NEGRO # 662 | CARTUCHO NEGRO #662 |   0 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
| TEHUACAN |  1803 | TINCHEPADESKJETADVANTAGE-2515ON0000001803 | # 662    | CZ103AL |  | CZ103AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP NEGRO # 662 | CARTUCHO NEGRO #662 |   0 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
| XALAPA  |  1803 | TINCHEPADESKJETADVANTAGE-2515ON0000001803 | # 662    | CZ103AL |  | CZ103AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP NEGRO # 662 | CARTUCHO NEGRO #662 |   1 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
| CORDOBA  |  1802 | TINCHEPADESKJETADVANTAGE-2515ON0000001802 | 662     | CZ104AL |  | CZ104AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP TRICOLOR # 662 | CARTUCHO # 662 TRICO |   0 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
| TEHUACAN |  1802 | TINCHEPADESKJETADVANTAGE-2515ON0000001802 | 662     | CZ104AL |  | CZ104AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP TRICOLOR # 662 | CARTUCHO # 662 TRICO |   0 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
| XALAPA  |  1802 | TINCHEPADESKJETADVANTAGE-2515ON0000001802 | 662     | CZ104AL |  | CZ104AL | HEPA | DESKJET ADVANTAGE-2515 | O  | TINC | N  | CARTUCHO TINTA ORIGINAL HP TRICOLOR # 662 | CARTUCHO # 662 TRICO |   1 |  0 |  16 |  0 |  0 | N  |    0 |  0 | 08/02/2014 | 08/02/2014 |    0 |    0 |  0 |  0 |     | A  |    |  | 08/02/2014 | COMPRAS | 01/01/1900 |   |   100 |   |     0 |     0 | 
+-------------+-------------+-------------------------------------------+----------------------+----------+-------+------------+-------+------------------------+----------+-------+-------+-------------------------------------------+----------------------+------------+-------+----------+----------+--------+--------+---------------+----------+------------+------------+---------------+---------------+--------+--------+------------------+---------+---------------+--------+------------+----------+------------+----------+-------------+------------+-------------------+-------------------+

表Kardex_Producto：

+-------------+---------------+-----------------+----------------------+----------+-------+----------+-------+--------+--------+------------------+------------+------------+------------------+-------------+------------------+--------------+---------------+---------+------------+-------------+------------+------------+ 
    | Id_Sucursal | Id_Movimiento | Tipo_Movimiento |  Num_Serie  | No_Parte | OEM | Cantidad | Costo | Codigo | Oferta | Ord_Compra | No_Factura | Ord_Salida | No_Transferencia | No_Contrato | No_Servicio | Aut_Especial | Observaciones | Estatus | F_Entrada | Usr_Entrada | F_Salida | Usr_Salida | 
    +-------------+---------------+-----------------+----------------------+----------+-------+----------+-------+--------+--------+------------------+------------+------------+------------------+-------------+------------------+--------------+---------------+---------+------------+-------------+------------+------------+ 
    | XALAPA  |   504 | E+    | 28837    |   | 28837 |  10 |  0 |  | N  | Traspaso No. 543 |   |   |     |    | Traspaso No. 543 |    |    | F  | 10/10/2016 | TCAXALGER | 01/01/1900 |   | 
    | XALAPA  |   504 | E+    | 32385    |   | 32385 |  5 |  0 |  | N  | Traspaso No. 543 |   |   |     |    | Traspaso No. 543 |    |    | F  | 10/10/2016 | TCAXALGER | 01/01/1900 |   | 
    | XALAPA  |   504 | E+    | 37069    | 37069 | 37069 |  10 |  0 |  | N  | Traspaso No. 543 |   |   |     |    | Traspaso No. 543 |    |    | F  | 10/10/2016 | TCAXALGER | 01/01/1900 |   | 
    | XALAPA  |   504 | E+    | TK-1147-172--137-162 | 44259 | 44259 |  10 |  0 |  | N  | Traspaso No. 543 |   |   |     |    | Traspaso No. 543 |    |    | F  | 10/10/2016 | TCAXALGER | 01/01/1900 |   | 
    | XALAPA  |   505 | E+    | # 662    | CZ103AL |  |  1 |  0 |  | N  | Traspaso No. 549 |   |   |     |    | Traspaso No. 549 |    |    | F  | 13/10/2016 | TCAXALGER | 01/01/1900 |   | 
    | XALAPA  |   505 | E+    | 662     | CZ104AL |  |  1 |  0 |  | N  | Traspaso No. 549 |   |   |     |    | Traspaso No. 549 |    |    | F  | 13/10/2016 | TCAXALGER | 01/01/1900 |   | 
    +-------------+---------------+-----------------+----------------------+----------+-------+----------+-------+--------+--------+------------------+------------+------------+------------------+-------------+------------------+--------------+---------------+---------+------------+-------------+------------+------------+

我试图做一个报告，显示了我，从表Kardex_Producto ，Id_Sucursal，Id_Movimiento，Cantidad，Costo，Ord_Compra，而不是num_serie或No_parte或OEM，显示来自Producto的Descr_Larga。

我想这样的说法：

SELECT 
    Producto.Descr_Larga, Kardex_Producto.Id_Sucursal, 
    Kardex_Producto.Id_Movimiento, Kardex_Producto.Cantidad, 
    Kardex_Producto.Costo, Kardex_Producto.Ord_Compra 
FROM 
    Kardex_Producto 
INNER JOIN 
    Producto ON Kardex_Producto.No_Parte = Producto.No_Parte 
      AND Kardex_Producto.Id_Sucursal = 'xalapa' 
WHERE 
    (Kardex_Producto.Id_Sucursal = 'xalapa' 
    AND Kardex_Producto.Id_Sucursal = Producto.Id_Sucursal) 
    AND (Kardex_Producto.F_Entrada >= CONVERT(DateTime, '20161001', 103)) 
     OR (Kardex_Producto.F_Salida >= CONVERT(DateTime, '20161001', 103))

，但它返回错误的结果，这样的：

+------------------------------------------------------+-------------+---------------+----------+-------+ 
|      Descr_Larga      | Id_Sucursal | Id_Movimiento | Cantidad | Costo | 
+------------------------------------------------------+-------------+---------------+----------+-------+ 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1102 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1104 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1122 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1125 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1125 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1133 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1146 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1146 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1147 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1134 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1138 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1141 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1142 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1144 |  1 |  0 | 
| TONER CARTUCHO REMANOFACTURADO      | XALAPA  |   1145 |  2 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1102 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1104 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1122 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1125 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1125 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1133 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1146 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1146 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1147 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1134 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1138 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1141 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1142 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1144 |  1 |  0 | 
| TONER CARTUCHO GENERICO EQUIVALENTE A TN-850 HP | XALAPA  |   1145 |  2 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1102 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1104 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1122 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1125 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1125 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1133 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1146 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1146 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1147 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1134 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1138 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1141 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1142 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1144 |  1 |  0 | 
| BALERO DE RODILLO DE PRESION       | XALAPA  |   1145 |  2 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1102 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1104 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1122 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1125 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1125 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1133 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1146 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1146 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1147 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1134 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1138 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1141 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1142 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1144 |  1 |  0 | 
| CHIP CARTUCHO XEROX 013R00601      | XALAPA  |   1145 |  2 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1102 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1104 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1122 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1125 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1125 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1133 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1146 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1146 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1147 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1134 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1138 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1141 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1142 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1144 |  1 |  0 | 
| LAMINA ALTERNO CANON IR-1600       | XALAPA  |   1145 |  2 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1102 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1104 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1122 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1125 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1125 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1133 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1146 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1146 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1147 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1134 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1138 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1141 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1142 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1144 |  1 |  0 | 
| TONER HP RECARGA COLOR NEGRO 55 GRS CHIP INCLUIDO | XALAPA  |   1145 |  2 |  0 | 
+------------------------------------------------------+-------------+---------------+----------+-------+

当结果应该是这样的

+----------------------+-------------------------------------------+-------------+---------------+----------+--------+------------------+------------+------------+ 
|  Num_Serie  |    Descr_Larga    | Id_Sucursal | Id_Movimiento | Cantidad | Costo | Ord_Compra | F_Entrada | F_Salida | 
+----------------------+-------------------------------------------+-------------+---------------+----------+--------+------------------+------------+------------+ 
| 28837    | TONER BOTELLA ALTERNO 220G    | Xalapa  |   504 |  10 | 398 | Traspaso No. 543 | 10/10/2016 | 01/01/1900 | 
| 32385    | TONER RECARGA GENERICO 100 G HP   | Xalapa  |   504 |  5 | 130 | Traspaso No. 543 | 10/10/2016 | 01/01/1900 | 
| 37069    | TONER RECARGA GENERICO 240 G SHARP  | Xalapa  |   504 |  10 | 230 | Traspaso No. 543 | 10/10/2016 | 01/01/1900 | 
| TK-1147-172--137-162 | TONER RECARGA GENERICO 290GR. KYOCERA | Xalapa  |   504 |  10 | 398 | Traspaso No. 543 | 10/10/2016 | 01/01/1900 | 
| # 662    | CARTUCHO TINTA ORIGINAL HP NEGRO # 662 | Xalapa  |   505 |  1 | 185.76 | Traspaso No. 549 | 13/10/2016 | 01/01/1900 | 
| 662     | CARTUCHO TINTA ORIGINAL HP TRICOLOR # 662 | Xalapa  |   505 |  1 | 185.76 | Traspaso No. 549 | 13/10/2016 | 01/01/1900 | 
+----------------------+-------------------------------------------+-------------+---------------+----------+--------+------------------+------------+------------+

但它是给出重复的信息，我不知道还有什么要尝试。任何帮助将非常感激。

预先感谢您！

你Kardex_Producto。 No_Parte为空...这与Producto.No_Parte无法匹配... – scaisEdge

是的，它在我用作示例的行中为空，其他行中有信息，与表中的No_Parte相匹配Producto –

You do知道OR最后被处理了吗？ – Paparazzi

答

但Kardex_Producto.No_Parte为null，所以这是行不通的
你需要决定加入什么样的，你可能需要更多的数据

我敢打赌，你的意思是这

SELECT Distinct 
     Producto.Descr_Larga, Kardex_Producto.Id_Sucursal, 
     Kardex_Producto.Id_Movimiento, Kardex_Producto.Cantidad, 
     Kardex_Producto.Costo, Kardex_Producto.Ord_Compra 
FROM Kardex_Producto 
JOIN Producto 
     ON Kardex_Producto.No_Parte = Producto.No_Parte 
     and Kardex_Producto.Id_Sucursal = 'xalapa' 
     and Kardex_Producto.Id_Sucursal = Producto.Id_Sucursal 
WHERE ( Kardex_Producto.F_Entrada >= CONVERT(DateTime, '20161001', 103) 
     OR Kardex_Producto.F_Salida >= CONVERT(DateTime, '20161001', 103) 
    )

谢谢@Paparazzi提供你的答案，但你的陈述给出了相同的结果。我更新了表格并添加了预期结果。希望能帮助你，帮助我... –

SQL Server：如何加入这两个表？

相关推荐