D
darien.watkins
Here is my SQL:
SELECT tblIssue.IssueNumber, tblFacility.FacilityName,
tblIssue.IssueBrief, tblIssue.IssueStatus FROM (tblIssue INNER JOIN
tblFacility ON tblIssue.FacilityID = tblFacility.FacilityID)
UNION ALL
SELECT tblIssue.IssueNumber, tblFacility.FacilityName,
tblIssue.IssueBrief, tblIssue.IssueStatus FROM (tblIssueRO INNER JOIN
tblFacilityRO ON tblIssue.FacilityID = tblFacility.FacilityID)
tblFacility and tblFacilityRO are identical
tblIssue and tblIssueRO are identical
Any ideas why my sql doesn't work? It comes up saying there were
errors configuring the adapter.
Darien
SELECT tblIssue.IssueNumber, tblFacility.FacilityName,
tblIssue.IssueBrief, tblIssue.IssueStatus FROM (tblIssue INNER JOIN
tblFacility ON tblIssue.FacilityID = tblFacility.FacilityID)
UNION ALL
SELECT tblIssue.IssueNumber, tblFacility.FacilityName,
tblIssue.IssueBrief, tblIssue.IssueStatus FROM (tblIssueRO INNER JOIN
tblFacilityRO ON tblIssue.FacilityID = tblFacility.FacilityID)
tblFacility and tblFacilityRO are identical
tblIssue and tblIssueRO are identical
Any ideas why my sql doesn't work? It comes up saying there were
errors configuring the adapter.
Darien