on 12-24-2010 2:43 PM
hola tengo el siguiente query:
SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand], T0.[IsCommited],T0.[OnOrder], T0.[MaxLevel], T0.[SuppCatNum], T0.[MinLevel], T0.[U_PROMEDIO], T0.[CodeBars],T1.[Name]'Clasificacion' FROM OITM T0 INNER JOIN [dbo].[@TABLA_CLASIF_ART] T1 ON T0.U_clasificacion = T1.Code
pero por la relacion con la tabla [dbo].[@TABLA_CLASIF_ART] me salen solo los que tienen T0.U_clasificacion
como hago para que me salga todos
gracias
SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand], T0.[IsCommited],T0.[OnOrder], T0.[MaxLevel], T0.[SuppCatNum], T0.[MinLevel], T0.[U_PROMEDIO], T0.[CodeBars],T1.[Name] FROM OITM T0 RIGHT JOIN [dbo].[@TABLA_CLASIF_ART] T1 ON T0.U_clasificacion = T1.Code
no salen todavia, es que al crear la relacion con esta otra tabla entonces me trae solo las lineas que tienen T0.U_clasificacion los otros no los muestra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ahora siii!!!! gracias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Buenas
Y si cambias el INNER por RIGHT JOIN?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.