Error in mysql query

Question

I am hours away from realizing what is wrong with my query. I would like you to give me a 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 as return this error:

#1054 - Unknown column 'transaccao_carregamento.transaccao_id' in 'on clause' 

Answer 1

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