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'

mysql delete query from 2 table

mysql delete query from 2 table :

 DELETE rbs_room_booking , rbs_sc_user  FROM rbs_room_booking  INNER JOIN rbs_sc_user WHERE rbs_room_booking.booking_id= rbs_sc_user.booking_id AND rbs_room_booking.booking_id = '310'

mysql active status show as Active and Inactive

mysql active status show as Active and Inactive :

rbs_user this table active_status Coloumn Default=N

SELECT user_id,user_name,e_mail,designation,CASE WHEN active_status ='Y' THEN 'Active' ELSE 'Inactive' END activestatus FROM rbs_user


activestatus is allias name 

java code:
public String userStatus(){
   
        System.out.println("kaniz");
       
         if(statusVal.equalsIgnoreCase("inactive")){
                status ="Y";
            } else {
                status ="N";
            }
       
   
       
         UsersSQL usersSQL = new UsersSQL();
         usersSQL.getUpdateTable(status,unikId); // use for update query
         
       
            //userDataList = usersSQL.selectUsersDate();// use for select query
           
        return "userStatus";       
       
    }