Get results regardless of record existence

[justspree]

Hi,

How do I retrieve record from the following regardless of whether there is result in tableB?

tableA
+------+-----------+
|  id  |  Article  |
+------+-----------+
|  1   |  Learn    |
+------+-----------+
|  2   |  Learn B  |
+------+-----------+

tableB
+------+-------------+
| id   |  articleID  |
+------+-------------+
|  1   |      1      |
+------+-------------+

Select * from tableA where tableA.id = tableB.articleID; 

The result I wanted is to retrieve all tableA articles regardless of whether there is a linkage in tableB?

Thx in advanced.

[r937]

use a LEFT OUTER JOIN

[justspree]

use a LEFT OUTER JOIN

Oh thanks Rudy! It works! Your' a life saver!