a guest Mar 24th, 2019 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT p.*,
- pr.id as related_id, pr.name as related_name, pr.price as related_price
- FROM products p
- LEFT JOIN products pr
- ON pr.id = ABS(p.id - 2)
RAW Paste Data