select a.id, a.account_no, b.balance from a, b where a.id=b.id; select id, account_no, balance from c where id=X;