on 11-17-2016 3:19 AM
Estimados expertos necesito de su gran ayuda, ando generando un query de pagos recibidos solo que quisiera agregar campos de OSLP (SlpName) y de OHEM (FirtsName)
esta es mi cosulta.
SELECT T0.[DocNum],
T0.[DocDate],
T0.[CardCode],
T0.[CardName],
T0.[CashSum],
T0.[CheckSum],
T0.[CreditSum],
T0.[TrsfrSum],
T0.[DocTotal],
T0.[CounterRef],
T0.[Comments],
T0.[JrnlMemo],
T0.[PrjCode]
FROM ORCT T0
WHERE T0.[DocDate] BETWEEN [%0] and [%1]
AND T0.Canceled = 'N'
de antemano agradezco su gran apoyo y de su valiosa ayuda.
Saludos.
eh??
No se que quieres decir con eso de combinación interna....
Ahi tienes la consulta sql que cumple con lo que pides....Ctrl+C y Ctrl+V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Si los datos que quieres añadir son los de la ficha del IC sería esto:
SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[CashSum], T0.[CheckSum], T0.[CreditSum], T0.[TrsfrSum], T0.[DocTotal], T0.[CounterRef], T0.[Comments], T0.[JrnlMemo], T0.[PrjCode], T2.[SlpName], T3.[firstName] FROM ORCT T0 inner join OCRD T1 on t0.cardcode=T1.cardcode LEFT JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode LEFT JOIN OHEM T3 ON T1.DfTcnician = T3.empID WHERE T0.[DocDate] BETWEEN [%0] and [%1] AND T0.Canceled = 'N'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Estimado Gonzalo mil gracias, tenía mal configurado mi explorador.
reitero mi gratitud por tu gran y valiosa ayuda.
Saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
en tú consulta aparece lo siguiente:
"[Nombre] dE ORCT T0 T1 Combinación interna OCRD en t0. cardcode ="
es por lo que no entiendo.
saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Estimado Gonzalo mil gracias por tu ayuda pero no entiendo eso de "combinacion interna"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
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.