Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
sql2 = "SELECT tblGeneral.ChartID, tblGeneral.Facility, tblGeneral.City, tblGeneral.State, tblGeneral.VISNID, " & _ "tblGeneral.FacName, tblGeneral.CorpName, " & _ "tblContractJournalsSubs.JournalID, " & _ "tblContractJournals.Title, tblContractJournals.Cost, tblContractJournals.Type, tblContractJournals.Vendor " & _ "FROM (tblGeneral INNER JOIN tblContractJournalsSubs ON tblGeneral.ChartID= tblContractJournalsSubs.ChartID) " & _ "INNER JOIN tblContractJournals on tblContractJournalsSubs.JournalID = tblContractJournals.JournalID " & _ "WHERE ChartID=" & ChartID & ";"
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!