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