Advertisement
touhid_xml

SQL subquery

Jun 6th, 2017
357
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.17 KB | None | 0 0
  1. SELECT `id`, (SELECT `place_name` FROM `place` WHERE `place`.`id` = (SELECT `place_id` FROM `hotel` WHERE `hotel`.`id` = `hotel_id`)) AS `place_name`,`tour_price` FROM `offer`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement