MS ACCESS DB help

Question

I have a c# program with a MS Access DB that holds various details about various things.

I have created a set of functions to build the sql requests / oledb requests for reading writing and counting e.t.c using RequestScalar, although now I have hit the limit of my knowledge of oledb and queries.

I have a table that contains a set of records each with a uniquie ID and other details including a category id. Each category ID can be used many times in this table for different records.

I have the category ID and I want to fetch all of the records that have this category ID.

Can anyone guide me in the right direction?

Thanks in advance
Adam

Suthish Nair · Answer

Using SQL Joins search for articles here. So that you can learn instead of we answering it.

adam · Answer

I have put some example data below YearGroups YearID Name 1 Year 7 2 Year 8 3 Year 9 4 Year 10 Students ID FirstName SecondName YearID 1 Billy James 1 2 Rob Smith 2 3 Jane Thomas 3 5 Lilly Pike 3 7 Bob Williams 3 8 Mitchel Sanders 4 9 George Smith 4 An example of what I want to do is.... I have the YearID 3 and I want to get a list of the first and second names of the students that are in that year.

Suthish Nair · Answer

can you provide the table structure. If using different tables use sql joins.