Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [soegame]> select storename, storetype, ownercharid, concat(c.firstgiven, " ", c.lastgiven) as name, u.forumaccount from stores s join characters c on c.charid = s.ownercharid join users u using(userid) where storetype = "chopshop";
- +------------------------+-----------+-------------+-------------+--------------+
- | storename | storetype | ownercharid | name | forumaccount |
- +------------------------+-----------+-------------+-------------+--------------+
- | Low Power Construction | ChopShop | 20269 | Ina Hansen | Bella |
- | Hayes Auto | ChopShop | 31765 | Brian Smith | Majic |
- | Back Alley | ChopShop | 251 | Bob Mcgrath | Talbot |
- +------------------------+-----------+-------------+-------------+--------------+
- 3 rows in set (0.22 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement