SELECT
A.KOLON as TANIM,
B.KOLON as TANIM2,
....
....
FROM
HESAP AS A
JOIN
BAKIYE AS B
ON A.KOLON=B.KOLON
Join tiplerine googledan bakarak işinize yarayan hangisi ise kullanabilirsiniz.
Ek filtreleme yapmak isterseniz;
A.KOLON as TANIM,
B.KOLON as TANIM2,
....
....
FROM
HESAP AS A
JOIN
BAKIYE AS B
ON A.KOLON=B.KOLON
WHERE
B.hesap_adi>= 'asd'