Hi all

I have two tables, one is category and another is articles,
For each category i have many articles in article table,
The articles table is related to category table via cat_id field,
I need to show a list of categories along with related articles,
I am able to retrieve records successfully from the tables the issue now is,
For a few categories there are no articles, I need to retrieve even such categories too!!

Currently I am able to retrieve data only for those categories which have related articles.
Question is How to retrieve category names even if there are no related articles

Any helping soul.....