0
I have the following query:
SELECT
sum(pedidos_lentes.quantidade) AS value,
pedidos_lentes.solar AS label FROM pedidos
JOIN pedidos_lentes ON pedidos_lentes.id_pedido = pedidos.id_pedido
WHERE id_loja = 2
group by pedidos_lentes.solar
The column label
returns the values 1 and 0, stored in the database. In the result, it is possible to swap these values for strings?
Thanks, but I fit using CASE.
– marcelo2605