a guest Jan 24th, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select e.id sr_id, e.name sr_name, r.id route_id, r.name route_name, o.id outlet_id, o.name outlet_name, o.address outlet_address
- from employee e
- join route r on r.sr_id = e.id
- join outlet o on o.route_id = r.id
- where e.id = 18;
RAW Paste Data