B
BillA
I am having a mental block as to how to return just 1 instance of records
from the INVESTIGATOR table. Each investigator may have many projects, that
is captured in a JOINING table using the relationshipID. The JOINING table
is my middle table of a Many-to-Many Relationship with a table PROJECTS.
Presently, I'm getting multiple instances of INVESTIGATORS because they
obviously work multiple PROJECTS.
Here is the SQL from my query thus far:
SELECT tbl_Investigator.*, lk_Join.InvestigatorRelationID
FROM tbl_Investigator INNER JOIN lk_Join ON tbl_Investigator.InvestigatorID
= lk_Join.InvestigatorID
WHERE (((lk_Join.InvestigatorRelationID)=1));
Again; I am trying to create a query that will return only a single record
from the INVESTIGATOR table.
Thank you.
Bill
from the INVESTIGATOR table. Each investigator may have many projects, that
is captured in a JOINING table using the relationshipID. The JOINING table
is my middle table of a Many-to-Many Relationship with a table PROJECTS.
Presently, I'm getting multiple instances of INVESTIGATORS because they
obviously work multiple PROJECTS.
Here is the SQL from my query thus far:
SELECT tbl_Investigator.*, lk_Join.InvestigatorRelationID
FROM tbl_Investigator INNER JOIN lk_Join ON tbl_Investigator.InvestigatorID
= lk_Join.InvestigatorID
WHERE (((lk_Join.InvestigatorRelationID)=1));
Again; I am trying to create a query that will return only a single record
from the INVESTIGATOR table.
Thank you.
Bill