I am not sure if append is the correct word. What I am trying to do is pull information from another database and put it at the end of the exisitng information I am showing. The following is my SQL query what I want to do is query another database with this query but have that information show up after the 1st query of information.
sql = "select orgstrUPC, orgstrUPC + ' - (' + orgstrUname + ')' from cms.dbo.tblOrganization " _
& "where orgstrUPC not in (select strUIC from tblUIC where intTaskForceID = " & id & ") " _
& "AND (orgstrUName NOT LIKE '%FMS%') AND (orgstrUName NOT LIKE '%FWD%') AND (orgstrUName NOT LIKE '%RSP%') " _
& "order by orgstrUPC"
After this query is finished I then need to show information from another database here as well. the database is cmsAF and the tables are strUIC and strUnit.
So in the end this would all be on big query that show all this unit information but the 1st query would show up first and then the second one would follow.