I need to create a querry that needs to have values of two
different columns to be looked up in another table. Ex.
Table: ChangeDetails
Column: Note
Column: PaperStatusID
Column: DigitalStatusID
Table: Status
Column: StatusID
Column: Description
I need a querry that will display the Note, Description from the
Status table (where PaperStatusID = StatusID), and Description from
the Status table (where DigialStatusID = StatusID).
I need this in a single query, but I'm not good at queries yet and
can't figure out how to do this.
Here is sample data to clarify what I need:
Table: ChangeDetails
Note: Parcel Drawn PaperStatusID: 3 DigitalStatusID: 2
Note: Dwelling mark removed PaperStatusID: 2 DigitalStatusID: 1
Note: Dwelling mark added PaperStatusID: 1 DigitalStatusID: 1
Table: Status
StatusID: 1 Description: Done
StatusID: 2 Description: Not Done
StatusID: 3 Description: Needs Research
Querry Result:
Parcel Drawn, Needs Research, Not Done
Dwelling mark removed, Not Done, Done
Dwelling mark added, Done, Done
Thanks in advance!