I'm on the clock without noticing what's wrong with my query. I would like you to give me some help
SELECT
'recargas'.'valor_recarga' as saldo
FROM 'contas_pessoais'
INNER JOIN 'contas' ON 'contas'.'titular' = 'contas_pessoais'.'titular'
INNER JOIN 'recargas' ON 'recargas'.'titular' = 'contas_pessoais'.'titular'
INNER JOIN 'transaccoes' ON 'transaccoes'.'transaccao_id' = 'transaccao_carregamento'.'transaccao_id'
WHERE 'contas'.'titular' = '12';
I have this error as a return:
#1054 - Unknown column 'transaccao_carregamento.transaccao_id' in 'on clause'