i have a question about mysql. I have multiple tables (Dresden, dusseldorf, England, etc) each one of this have the following fields (Name, loginname, macaddress). Some users are in more than one table (the same user can be in two or more of this tables.) I want to create a table where i can see all users. I was wondering if it is possible to add a field at the end of each raw telling where if come from and to merge all repeated files. I hope i made myself clear.... i am really new to mysql....

Best regards...

Here are my tables:

Dusseldorf:

```
--------------------------------
|Username | value | macaddress |
-------------------------------
|jose     | 10    | 00:00:00:00|
--------------------------------
|maria    | 20    | 00:00:00:01|
--------------------------------

```

Dresden:

```
--------------------------------
|Username | value | macaddress |
--------------------------------
|jose     | 10    | 00:00:00:00|
--------------------------------
|maria    | 20    | 00:00:00:01|
--------------------------------
|juan     | 15    | 00:00:00:02|
--------------------------------

```

England:

```
--------------------------------
|Username | value | macaddress |
-------------------------------
|jose     | 10    | 00:00:00:00|
-------------------------------
|maria    | 20    | 00:00:00:01|
--------------------------------
|pedro    | 20    | 00:00:00:03|
--------------------------------

```

All together:

```
-----------------------------------------------------------------
|Username | value | macaddress | Dusseldorf | Dresden | England |
-----------------------------------------------------------------
|jose     | 10    | 00:00:00:00|     X      |    X    |    X    |
-----------------------------------------------------------------
|maria    | 20    | 00:00:00:01|     X      |    X    |    X    |
-----------------------------------------------------------------
|juan     | 15    | 00:00:00:02|            |    X    |         |
-----------------------------------------------------------------
|pedro    | 20    | 00:00:00:03|            |         |    X    |
-----------------------------------------------------------------

```