Hi,
How do I retrieve record from the following regardless of whether there is result in tableB?
The result I wanted is to retrieve all tableA articles regardless of whether there is a linkage 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;
Thx in advanced.



Reply With Quote
Bookmarks