Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- snack=> select app_stores.name, app_stores.external_id, app_users.email, app_users.external_id from app_stores left join app_users on app_users.id = app_stores.user_id;
- name | external_id | email | external_id
- ------------------+--------------------------------------+----------------+--------------------------------------
- Розничный склад | 8b6a573a-babe-11e6-810d-00155d141403 | | e9ea003d-218a-11e6-986f-74d435f9178c
- Склад №3 | 71e39c79-24a2-11e6-8624-74d435f9178c | | 7f52927a-b181-11e6-810a-00155d141403
- тестовый склад | e9ea003d-218a-11e6-986f-74d435f9178c | | a3ceaceb-f68c-4427-871a-016ecbb7c823
- Склад №1 | f3a8f07d-218a-11e6-986f-74d435f9178c | | 1e15ddab-b177-11e6-810a-00155d141403
- Склад №2 | 86fb06a2-218b-11e6-986f-74d435f9178c | | 5395ea3a-b181-11e6-810a-00155d141403
- Склад №5 | 951d8063-218b-11e6-986f-74d435f9178c | | bb09cbb9-b181-11e6-810a-00155d141403
- Склад №4 | befbb993-218c-11e6-986f-74d435f9178c | | 9e5232f1-b181-11e6-810a-00155d141403
- WEB TEST STORE 3 | e0861ef2-791a-43e9-a43b-a1e13476d034 | | 9ca0cd3a-2188-11e6-986f-74d435f9178c
- WEB TEST STORE 2 | ccddc978-7b1d-4a0a-8af7-e14b31bdfc8e | | a6885304-1ae5-11e6-8614-74d435f9178c
- WEB TEST STORE 1 | e2d22bd0-7507-4dd7-b48f-799ecb289ba7 | u1@example.com | 8ddea434-7ae4-4436-ace1-5ff33a635ffa
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement