Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- users table:
- -------------------------
- id | name | email
- 1 | john | j@mail.com
- 2 | eric | e@mail.com
- -------------------------
- orders table
- -------------------------
- id | user_id | name | details
- 1 | 1 | order1 | stuff for order 1
- 2 | 1 | order2 | stuff for order 2
- 3 | 1 | order3 | stuff for order 3
- 4 | 2 | order4 | stuff for order 4
- 5 | 2 | order5 | stuff for order 5
- -------------------------
- I want to query the db so I get the following format in return:
- _______________________________________________________________
- 1 | john | j@mail.com | order1 | stuff for order 1 | order2 | stuff for order 2 | order3 | stuff for order 3
- 2 | eric | e@mail.com | order4 | stuff for order 4 | order5 | stuff for order 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement