accounts = from a in accounts<br /> join ab in accountBalance<br /> on a.ACCOUNT_ID equals ab.ACCOUNT_ID<br /> where ab.CURRENCY_ID == currencyID<br /> select a;
var