Skip to Content
Author's profile photo Former Member

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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.