Posted by nick on 09/14/07 14:43

Hi,

I have the following three tables below containing Resources,
Categories and a link table so each Resource can belong to one or more
Categories. I would like to create a view (ResourceID, ResourceName,
CategoryID, CategoryName) that includes one row for each Resource with
just one of the Categories that it belongs to.

Resource table
- ResourceID
- ResourceName
- etc..

Category table
- CategoryID
- CategoryName
- etc..

ResourceCategory table
- ResourceID
- CategoryID

Can anyone help? Thanks.

• Next in forum: Select Records and Insert into Text File?
• Prev in forum: Re: SET NO_BROWSETABLE ON ?
• Thread view: Reducing many-to-many to one-to-one

[Reply to this message]