SELECT *
FROM  `konton`
join bank on(bank.id=konton.bankid)
where konton.bank='Lantm��nnen Finans'