Error in mysql query

0

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' 
    
asked by anonymous 26.08.2015 / 16:13

1 answer

2

The transaction-load table is not in your query, you need to include it in an INNER JOIN.

    
26.08.2015 / 16:28