how to create category with SQLITE in iphone [closed]

Closed. This question needs details or clarity. It is not currently accepting answers.

---

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 9 years ago.

Improve this que开发者_运维百科stion

i have a sqlite database like this :

table1:

categoryID     name   description
    1            a         dog
    1            b          cat
    2            c          elephant
    2            d        bird

table2:

categoryID      categoryName
    1               ex1
    2                ex2
    3               ex4

how to want to create category in first view with categoryID and categoryName ?

---

Do you mean a join? Some like: SELECT Table1.name, Table2.CategoryName FROM Table1, Table2 WHERE Table1.categoryId = Table2.categoryId AND Table1.categoryId = 1;