I need two different results coming in the same table with JOIS
It works like this
I have the PRODUCAO table and the BANK table
In the production table, I get the bank ID in the bank bank and it returns the bank name, but I have a second field called BANCO_SALDO
It takes the same BANK table as the bank ID and returns the name of the bank.
How can I relate these two tables and show me the names in each field I need?
SELECT * FROM producao
JOIN promotora ON id_promotora = promotora_produ
JOIN banco ON id_banco = banco_produ
JOIN B AS banco ON id_banco = banco_port_produ