I
iwasinnihon
I am having difficulty creating the Query that I want. I have 2 tables
that share a single field with a 3rd table. I want to create a query
that will list all of the information from both tables without
combining the information. I want to only have one column for the
shared field. The problem that I am having is that it will combine the
information from the two table next to the shared field. I guess I am
trying to do a Union instead of a Join. How do you do this?
Sorry if this doesn't make sense. I am finding it difficult to explain
myself in writing.
that share a single field with a 3rd table. I want to create a query
that will list all of the information from both tables without
combining the information. I want to only have one column for the
shared field. The problem that I am having is that it will combine the
information from the two table next to the shared field. I guess I am
trying to do a Union instead of a Join. How do you do this?
Sorry if this doesn't make sense. I am finding it difficult to explain
myself in writing.