Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------+--------------+------------+-----------------+-----------------+------------------+--------------+-------------------+-------------------+--------------------+----------------+-----------------+---------------------+----------------------+
- | account_no | company_name | admin_name | admin_email | admin_phone_src | admin_mobile_src | billing_name | billing_email | billing_phone_src | billing_mobile_src | technical_name | technical_email | technical_phone_src | technical_mobile_src |
- +------------+--------------+------------+-----------------+-----------------+------------------+--------------+-------------------+-------------------+--------------------+----------------+-----------------+---------------------+----------------------+
- | 1 | Company 1 | John | john@email.com | 0123456789 | | Dave | dave@email.com | 0123455789 | | John | john@email.com | 0123456789 | |
- | 2 | Company 2 | Sarah | sarah@email.com | 0123466789 | 0723456781 | Sarah | sarah@email.com | 0123466789 | 0723456781 | Sarah | sarah@email.com | 0123466789 | 0723456781 |
- | 3 | Company 3 | James | james@email.com | 0123477789 | 0743456788 | Richard | richard@email.com | 0123444789 | 0723444781 | Tom | tom@email.com | 0123433789 | 0723458881 |
- +------------+--------------+------------+-----------------+-----------------+------------------+--------------+-------------------+-------------------+--------------------+----------------+-----------------+---------------------+----------------------+
- +------------+--------------+---------+-------------------+------------+------------+-------------------------+
- | account_no | company_name | name | email | phone_src | mobile_src | role |
- +------------+--------------+---------+-------------------+------------+------------+-------------------------+
- | 1 | Company 1 | John | john@email.com | 0123456789 | | Admin,Technical |
- | 1 | Company 1 | Dave | dave@email.com | 0123455789 | | Billing |
- | 2 | Company 2 | Sarah | sarah@email.com | 0123466789 | 0723456781 | Admin,Billing,Technical |
- | 3 | Company 3 | James | james@email.com | 0123477789 | 0743456788 | Admin |
- | 3 | Company 3 | Richard | richard@email.com | 0123444789 | 0723444781 | Billing |
- | 3 | Company 3 | Tom | tom@email.com | 0123433789 | 0723458881 | Technical |
- +------------+--------------+---------+-------------------+------------+------------+-------------------------+
- SELECT account_no, company_name, admin_name AS 'Name', admin_email AS 'Email', admin_phone_src AS 'Phone', admin_mobile_src AS 'Mobile', 'Admin' AS role FROM account
- UNION
- SELECT account_no, company_name, billing_name AS 'Name', billing_email AS 'Email', billing_phone_src AS 'Phone', billing_mobile_src AS 'Mobile', 'Billing' AS role FROM account
- UNION
- SELECT account_no, company_name, technical_name AS 'Name', technical_email AS 'Email', technical_phone_src AS 'Phone', technical_mobile_src AS 'Mobile', 'Technical' AS role FROM account
- SELECT t.account_no, t.company_name, t.Name, t.Email, t.Phone, t.Mobile, GROUP_CONCAT(t.role) FROM (
- SELECT account_no, company_name, admin_name AS 'Name', admin_email AS 'Email', admin_phone_src AS 'Phone', admin_mobile_src AS 'Mobile', 'Admin' AS role FROM account
- UNION
- SELECT account_no, company_name, billing_name AS 'Name', billing_email AS 'Email', billing_phone_src AS 'Phone', billing_mobile_src AS 'Mobile', 'Billing' AS role FROM account
- UNION
- SELECT account_no, company_name, technical_name AS 'Name', technical_email AS 'Email', technical_phone_src AS 'Phone', technical_mobile_src AS 'Mobile', 'Technical' AS role FROM account
- ) t
Add Comment
Please, Sign In to add comment