Selecting from multiple tables

[mikawhat]

Hi ppl,
I need some help with sql queries. I'm following a book's tutorial and i want to customise it a bid. I've got the following table structure:

---

| content |

---

| id | ctext | cdate |

---

---

| contentcategory |

---

| contentid | categoryid |

---

---

| category |

---

| id | name |

---

When i enter ctext in contents table i select a category for it. What i need is to display in a table ctext and also the category that is associated with it.

---

| content.ctext | category.name |

---

Can anybody help me with this? Thanx!

[laserlight]

Perhaps something like:

SELECT content.ctext, category.name
	FROM content, category, contentcategory
	WHERE content.id=contentcategory.contentid
		AND category.id=contentcategory.categoryid;

[mikawhat]

great!! thanx a lot!

[mikawhat]

I need help for one more thing... when i enter the 'ctext' i have to select the category for it. I want only one entry for each category, so how can i check if a category is associated to a content or not? Is that possible with the current table structure?