I have 2 tables, faq and faq\_categories, and I want to join them to get the category name from the table faq\_categories.

The only field that I need from the faq\_categories is the name, while from the faq table, I need all fields.

I have the following syntax (which works) that I would like to make it shorter.

Here is the code:

```
     SELECT faq.faqid, faq.catid, faq.question, faq.question_en, faq.answer,       
        faq.answer_en, faq.sorder, faq.visible, 
        faq_categories.categoryname
FROM faq
JOIN faq_categories ON ( faq.catid = faq_categories.catid ) 

```

I am trying to select all fields with this code:

```
 SELECT * , faq_categories.categoryname
 FROM faq
 JOIN faq_categories ON ( faq.catid = faq_categories.catid ) 
 LIMIT 0 , 30

```

But this syntax returns me all fields from both tables which is not what I want. What I want is to get all fields from faq, and only categoryname from faq\_categories. 

First code snippets works, but I want to make it shorter if that is possible.

Any help will be deeply appreciated.

Regards, Zoran