I am working on a VB project that has to use a C++ dll that provides some look up function. The original VB6 code followed the example at http://support.microsoft.com/kb/107750, but this is no longer applicable for a number of reasons under VB 2008.
I have a query that works off one set of tables. However there are several sets of tables that are the same and I want to combine all the information into one query if possible. eg. SELECT