Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- elect p.shipid,
- p.shipname,
- c.DESC ContactShipCOM,
- a.DESC SpacialCoordiantes
- FROM PROFILE p
- LEFT JOIN contact c ON p.id = c.profileid
- AND c.ord = 1
- LEFT JOIN address a ON p.id = a.profileid
- AND a.ord = 1
- WHERE p.shipid = 'Rocinante'
- AND c.show='The Expanse'
Advertisement
Add Comment
Please, Sign In to add comment
