From bdd9f8780b76ad7cd806ce71b55c0882db56549b Mon Sep 17 00:00:00 2001 From: Mateus Cruz Date: Wed, 7 Feb 2024 23:36:22 -0300 Subject: fix query --- lib/query.ml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/query.ml b/lib/query.ml index 40a2c22..9b74b80 100644 --- a/lib/query.ml +++ b/lib/query.ml @@ -30,7 +30,7 @@ module Q = struct get_opt {sql| SELECT clients.id as @int{id}, @int{mov_limit}, value as @int{balance} FROM clients - JOIN balances ON balances.client_id = %int{id} + JOIN balances ON balances.client_id = clients.id WHERE clients.id = %int{id} |sql} record_out] -- cgit v1.2.3