SHARE
TWEET

Untitled

a guest Jul 20th, 2019 82 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. tbl_Friend                                    tbl_Colleague
  2.  
  3. | id | Name | First name | Place |            | id | Name | First name | Place |
  4. ----------------------------------            ----------------------------------
  5. |  1 | XXXX | XXXXXXXXXX |   1   |            |  1 | AAAA | AAAAAAAAAA |   1   |
  6. |  2 | YYYY | YYYYYYYYYY |   2   |            |  2 | BBBB | BBBBBBBBBB |   3   |
  7. |  3 | ZZZZ | ZZZZZZZZZZ |   1   |            |  3 | CCCC | CCCCCCCCCC |   4   |
  8.      
  9. | id | Name | First name | Place |
  10. ----------------------------------
  11. |  1 | XXXX | XXXXXXXXXX |   1   |
  12. |  1 | AAAA | AAAAAAAAAA |   1   |
  13. |  3 | ZZZZ | ZZZZZZZZZZ |   1   |
  14.      
  15. SELECT id, Name, First name, Place FROM tbl_Friend
  16.   WHERE Place= 1
  17. UNION ALL
  18. SELECT id, Name, First name, Place FROM tbl_Colleague
  19.   WHERE Place= 1
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top