Combining two Queries
Here is my problem. I have two different queries, where both, by intention, have the same field names. I need to take those two different queries and merge the information in to one query.
One query takes information about books and courses. The other query takes information about software and courses. Now, they need to be merged into one massive query and I'm not sure the best way to do it. The reason I have them have fields with the same name is because the software/course table doesn't have all the information that the books/courses does, so I have the software/course query generating empty fields in the appropriate places.
Any help is appreciated.