Hi,

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

PHP Code:
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.