I'm having a problem with this:
I have 3 tables.
Two of them together have the same information as the third one, with the difference that they have different field names and the two first have a little bit more info about other things.
I want to do a query and show the info that I want in one table, which must have common field names.
For example, one table has this fields:
the other two tables have this info:
(The users and documents from the first table are different as the other tables.)
I want make a single table with the fields "user" and "documents" and have the users and documents of all 3 tables in there.
How can I do this? Is this possible? Where could I get more information about this?