[SOLVED] Firebird SQL
lazarus / 16-Databases

----------------------------------------------------------------------
Fahmy Rofiq · 2014-12-02 05:58

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 · 2014-12-02 07:13

Code: [Select]Select
  TableB.A, TAbleA.B
from
  TableA
Inner join TableB on TableA.A = TableB.B

----------------------------------------------------------------------
Fahmy Rofiq · 2014-12-02 08:04

Great, thank you taazz