Add in base SQL in a letter

0

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.

    
asked by anonymous 09.11.2017 / 18:41

0 answers