I am having difficulty creating a database and listing 3 tables: return the customer's name and surname, your neighborhood, and the values of your movements, the date ordering the movements for this sql command to work
SELECT ClienteNome, ClienteSobrenome, ClienteBairro, MovimentoData,MovimentoValor
FROM Clientes, Contas, Movimentos
WHERE Clientes.ClienteCodigo=Contas.ClienteCodigo
AND Contas.ContaNumero=Movimentos.ContaNumero
ORDER BY MovimentoData desc;
I made a comment to better understand your goal.
But one thing is clear is that you are accessing the fields in the wrong way: You should write
SELECT Cliente.Nome, Cliente.Sobrenome, Cliente.Bairro, Movimentos.Data, Movimentos.Valor
You also called the wrong name from Table Movimentos , and wrote Movimento
I better detail the purpose of updating the answer!
Try this way, pay attention to select because the names of the tables in it were written incorrectly.
SELECT Clientes.Nome, Clientes.Sobrenome, Clientes.Bairro, Movimentos.Data, Movimentos.Valor
FROM Clientes, Contas, Movimentos
WHERE Clientes.Codigo = Contas.Codigo
AND Contas.Numero = Movimentos.Numero
ORDER BY Movimento.Data desc;