SELECT * EXCEPT a2.aid
       FROM accounts a
        LEFT JOIN accountrecords a2 ON a2.aid = a.aid;