This isn't a join, it's two files with identical layouts, but different
field names and different category of data. Otherwise the files are
When a user does a search, they can search file A, file B, or both. So I'd
like to try to write this dynamic enough so all I do is check the search
flags they set and build my SQL appropriatly. Especially when they search
both so it will "mesh" the data from the two files in the result set.