J
JohnLute
Duane:
FYI I just found a small oversight. The SQL needs to have the joins as LEFT
otherwise the report won't generate should there be a NULL value for
RDIngPKID and PreRDIngPKID:
SELECT tblProfiles.*, tblProfilesRevisions.*, tblProfiles_1.Description AS
RDIngPKIDDescription, tblProfiles_2.Description AS PrevRDIngPKIDDescription
FROM tblProfiles INNER JOIN ((tblProfilesRevisions LEFT JOIN tblProfiles AS
tblProfiles_1 ON tblProfilesRevisions.RDIngPKID = tblProfiles_1.txtProfileID)
LEFT JOIN tblProfiles AS tblProfiles_2 ON tblProfilesRevisions.PrevRDIngPKID
= tblProfiles_2.txtProfileID) ON tblProfiles.txtProfileID =
tblProfilesRevisions.txtProfileID;
FYI I just found a small oversight. The SQL needs to have the joins as LEFT
otherwise the report won't generate should there be a NULL value for
RDIngPKID and PreRDIngPKID:
SELECT tblProfiles.*, tblProfilesRevisions.*, tblProfiles_1.Description AS
RDIngPKIDDescription, tblProfiles_2.Description AS PrevRDIngPKIDDescription
FROM tblProfiles INNER JOIN ((tblProfilesRevisions LEFT JOIN tblProfiles AS
tblProfiles_1 ON tblProfilesRevisions.RDIngPKID = tblProfiles_1.txtProfileID)
LEFT JOIN tblProfiles AS tblProfiles_2 ON tblProfilesRevisions.PrevRDIngPKID
= tblProfiles_2.txtProfileID) ON tblProfiles.txtProfileID =
tblProfilesRevisions.txtProfileID;