Good afternoon!
In a database I have two tables. A call to Accounts, where you have for example a column of accounts 1 (Active), 1111 (Bank), 1112 (Banks), 1113 (Receipts).
Another table called Values where you have the value of the accounts, but this table has only 4-digit account values. Ex: 1111 (Cash).
I need to make the sum of all accounts that the first character is "1", thus getting the value of account 1 (Active).
Thank you very much in advance.