Reporte de SN pr lista de precios
Cordial Saludo:
Envio reporte de los clientes vinculados con un lista de precios.
SELECT T0.[ListNum], T0.[CardCode],T0.[LicTradNum], T0.[CardName], T2.[ListName], T1.[SlpName] FROM [dbo].[OCRD] T0 INNER JOIN [dbo].[OSLP] T1 ON T0.SlpCode = T1.SlpCode INNER JOIN OPLN T2 ON T0.ListNum = T2.ListNum WHERE T2.[ListName] Between [%0] and [%1] and T0.[CardType] = ‘C’
A espera de sus comentarios.
Be the first to leave a comment
You must be Logged on to comment or reply to a post.