I did some searching before deciding to ask, but here is my issue.
This is my entire query. A.Variable represents one of three categories, and when I include "A.Variable = 'Value'" my query only returns rows that contain this value.
More context:
Because of issues beyond my control, I have to deal with three different categories that do not have a unique id. A unique identifier consists of the id + category. I need to pull in a name that correlates to the id + category combination.
Any help here would be awesome. I'm coming from programming in SAS, and Access has so far been a struggle.
select A.*
, B.Name
from Table1 as A
left join Table2 as B
on (A.Id = B.Id
and A.Variable = "Value");
This is my entire query. A.Variable represents one of three categories, and when I include "A.Variable = 'Value'" my query only returns rows that contain this value.
More context:
Because of issues beyond my control, I have to deal with three different categories that do not have a unique id. A unique identifier consists of the id + category. I need to pull in a name that correlates to the id + category combination.
Any help here would be awesome. I'm coming from programming in SAS, and Access has so far been a struggle.