SELECT *
FROM  `konton`
join bank on(bank.id=konton.bankid)
where konton.bank='Sparbanken ��resund'