Thursday, April 30, 2015

mysql using JOIN query by three table

mysql using JOIN query by three table :

     SELECT b.`booking_id`, r.`ud_room_id`,r.room_name, u.`name`, u.`contact_no`, u.`designation`, u.`department`, b.`title` , b.`booking_date` , DATE_FORMAT( b.`start_time` , '%H:%i' ) start_time, DATE_FORMAT( b.`end_time` , '%H:%i' ) end_time
    FROM `rbs_room_booking` b
    JOIN `rbs_room` r ON r.`room_id` = b.`room_id`
    JOIN `rbs_user` u ON u.`user_id` = b.`entered_by`

    WHERE b.`booking_date`='2015-04-30'

No comments:

Post a Comment