tbl_Friend                                    tbl_Colleague

| id | Name | First name | Place |            | id | Name | First name | Place |
----------------------------------            ----------------------------------
|  1 | XXXX | XXXXXXXXXX |   1   |            |  1 | AAAA | AAAAAAAAAA |   1   |
|  2 | YYYY | YYYYYYYYYY |   2   |            |  2 | BBBB | BBBBBBBBBB |   3   |
|  3 | ZZZZ | ZZZZZZZZZZ |   1   |            |  3 | CCCC | CCCCCCCCCC |   4   |

| id | Name | First name | Place |
----------------------------------
|  1 | XXXX | XXXXXXXXXX |   1   |
|  1 | AAAA | AAAAAAAAAA |   1   |
|  3 | ZZZZ | ZZZZZZZZZZ |   1   |

SELECT id, Name, First name, Place FROM tbl_Friend
  WHERE Place= 1
UNION ALL
SELECT id, Name, First name, Place FROM tbl_Colleague
  WHERE Place= 1