on 04-08-2011 10:40 PM
Buenas tardes
Estoy tratando de enlazar una orden de compra con una entrada de mercancia, cuales serian los campos para poderlo hacer en una query de sql?
Gracias.
Quintaro
SELECT DISTINCT T0.DocNum'OC', T2.DocNum'Entrada Mercaderias'
FROM OPOR T0
INNER JOIN PDN1 T1 ON T1.BaseEntry = T0.DocEntry
INNER JOIN OPDN T2 ON T2.DocEntry = T1.DocEntry
PDN1.BaseEntry = DocEntry del documento base
PDN1.BaseLine = Linea del documento base
PDN1.BaseType = Tipo de Objecto del Documento Base
Slds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yo re recomiendo que lo hagas por medio de left joins
from por1 a left join pdn1 b on a.docentry=b.baseentry and a.linenum=b.baseline
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.