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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.