Help with SQL statement..

I have two SQL statements that I just can't seem to join together I provided screen show of both. Basically I need help INNER JOINing the two tables and I seem to keep on getting an error. Statement 1 which works fine: SELECT [login to view URL], aa.meta_block_timestamp, aa.blockchain_transaction_id, SUM(aa.value_int) FROM ( SELECT DISTINCT [login to view URL], transactions.blockchain_transaction_id, transactions.meta_block_timestamp, to_val, value_int FROM accounts INNER JOIN transactions ON [login to view URL] = [login to view URL] INNER JOIN blockchain ON [login to view URL] = transactions.blockchain_transaction_id INNER JOIN clauses ON [login to view URL] = clauses.transaction_id WHERE [login to view URL] = LOWER('0xe0EB562acD5F10A60EB3c37886C58fe90d7086BE') ) as aa GROUP BY [login to view URL], aa.meta_block_timestamp, aa.blockchain_transaction_id ORDER BY aa.meta_block_timestamp DESC returns: [login to view URL] ================================================================= statement 2 works fine which is: SELECT * FROM ( SELECT [login to view URL], count(yy.to_val) FROM ( SELECT DISTINCT transaction, clauses.to_val FROM transactions INNER JOIN clauses ON [login to view URL] = clauses.transaction_id WHERE [login to view URL] = LOWER('0x90154fb433a6f2a308fd0b27e50f4a29d22c1cb8c7e4b00cbf608dd0b0019ce8') ) as yy GROUP BY [login to view URL] ) as kk and returns [login to view URL] ================================================================= what I am trying to do INNER JOIN statement1 statement2 via [login to view URL] I have tried the following code: SELECT [login to view URL], aa.meta_block_timestamp, aa.blockchain_transaction_id, COUNT(aa.to_val), SUM(aa.value_int) FROM ( SELECT DISTINCT [login to view URL], transactions.blockchain_transaction_id, transactions.meta_block_timestamp, to_val, value_int FROM accounts INNER JOIN transactions ON [login to view URL] = [login to view URL] INNER JOIN blockchain ON [login to view URL] = transactions.blockchain_transaction_id INNER JOIN clauses ON [login to view URL] = clauses.transaction_id WHERE [login to view URL] = LOWER('0xe0EB562acD5F10A60EB3c37886C58fe90d7086BE') ) as aa INNER JOIN ( SELECT [login to view URL], count(yy.to_val) FROM ( SELECT DISTINCT transaction, clauses.to_val FROM transactions INNER JOIN clauses ON [login to view URL] = clauses.transaction_id WHERE [login to view URL] = [login to view URL] GROUP BY [login to view URL] ) as yy ) as BB on [login to view URL] = [login to view URL] GROUP BY [login to view URL], [login to view URL], aa.meta_block_timestamp, aa.blockchain_transaction_id ORDER BY aa.meta_block_timestamp DESC ============================== but I am getting an error of : ERROR: invalid reference to FROM-clause entry for table "aa" LINE 1: ...s.transaction_id WHERE [login to view URL] = aa.transac... ^ HINT: There is an entry for table "aa", but it cannot be referenced from this part of the query. (execution time: 266 ms; total time: 516 ms) ================================