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.