Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

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.

Labels in this area