SQL Q again

From: Jeffrey Keung <jsykeun_at_htechs.com>
Date: Mon, 13 Jul 1998 16:52:44 +0800
Message-ID: <35A9CADC.332B0D2D_at_htechs.com>

I have 2 tables, Table A with column : ID and Data1 & Table B wth column ID and Data2
now for example I have these data in both table: Table A :
ID Data1

---

1        A
2        B
4        C

and Table B:
ID Data2

---

2        XX
3        YY
5        ZZ

what SQL statement I should write in order to have the following output :
ID Data1 Data2

---

1            A
2            B                XX
3                               YY
4            C
5                                ZZ

Thank u! Received on Mon Jul 13 1998 - 10:52:44 CEST