Get results regardless of record existence

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.

use a LEFT OUTER JOIN

:slight_smile:

Oh thanks Rudy! It works! Your’ a life saver! :smiley: