[SOLVED] Firebird SQL

[Fahmy Rofiq]

Hi everyone,
I have two tables

Table A:
A           B
---------------------
TES       KET PERTAMA
ISI        KET KEDUA

Table B:
A           B
---------------------
SATU    TES
DUA      ISI
TIGA     TES

What query to get result like this:
A           B
---------------------
SATU    KET PERTAMA
DUA      KET KEDUA
TIGA     KET PERTAMA

Thank you

[taazz]

Code: [Select]

Select
  TableB.A, TAbleA.B
from
  TableA
Inner join TableB on TableA.A = TableB.B


[Fahmy Rofiq]

Great, thank you taazz