I want to update my conference_room_booking table by checking time slot availability on booking date or upcoming date

Question

I have two table room_detail and conference_room_booking

room_detail       conference_room_booking
-------------     ------------------------
room_id PK        room_booking_id PK
room_name         room_id
no_of_seat        user_id
                  date
                  from_time
                  to_time
                  room_status
                  creation_time

User already booked room and wants to update conference_room_booking
table by checking availability of time slot(eg-2-4,5-7,9-10) on that day or
other day, and can change room_name also.

Condition: user should not book the past date or time

How to do that in sql query? What portion can be done in sql query? Please help.

i don't know how to write this query. i dint write any code for it. i am asking to write query — Gopal Prasad, Mar 23 '17 at 23:33
you've got to try it first dude.. we are not spoon-feeding people here. we let them learn by correcting — RoMEoMusTDiE, Mar 23 '17 at 23:34
haha k bro.... can you tell how to do it... not asking code ...just process — Gopal Prasad, Mar 23 '17 at 23:37
will ask you in better way.. how to search and update in one query — Gopal Prasad, Mar 23 '17 at 23:47

score 0 · Answer 1 · edited May 23 '17 at 12:10

0

https://stackoverflow.com/a/2334741/1385774

UPDATE
    Table_A
SET
    Table_A.col1 = Table_B.col1,
    Table_A.col2 = Table_B.col2
FROM
    Some_Table AS Table_A
    INNER JOIN Other_Table AS Table_B
        ON Table_A.id = Table_B.id
WHERE
    Table_A.col3 = 'cool'

edited May 23 '17 at 12:10

Community

1
1

answered Mar 23 '17 at 23:54

RoMEoMusTDiE

4,739
1
17
26

I want to update my conference_room_booking table by checking time slot availability on booking date or upcoming date

1 Answers1