SELECT [Posting Date] AS fecha,[G_L Account No.] AS cuenta,[Name] AS nombre,[Amount] AS importe FROM [Ind. Campollano Ferretería S.L$G_L Entry] e LEFT JOIN [Ind. Campollano Ferretería S.L$G_L Account] c ON e.[G_L Account No.] = c.[No.] WHERE [Posting Date] BETWEEN CONVERT(date,'2025-01-01') AND CONVERT(date,'2025-06-30')