Apreciados Sres.

 

Me podria ayudar a colocar en este query el campo de titular que aparace en la orden de compra.

 

SELECT TOP 1 T0.DocNum, T0.DocDate, T0.CardCode, T0.CardName, T0.NumAtCard, T1.ItemCode, T1.Quantity FROM OPDN T0 INNER JOIN PDN1 T1 ON T1.DocEntry = T0.DocEntry WHERE T1.BaseEntry IS NOT NULL ORDER BY T0.DocNum DESC

 

saludos,

 

alberto

Filter Blog

By author:
By date: By tag: