I use MySQL to update my table
So i have two tables. They are seat and seat_status
Here are the structure of both:
seat
------------------------------
id_seat number(3) AI, PK;
seat_num varchar(3);
seat_status
-----------------------------------
id_seat_status number(3) AI, PK;
id_seat number(3) FK;
status varchar(14);
And here is MySQL query to update the status column in seat_status table:
UPDATE seat_status SET ss.status = 'Reserved' from seat_status ss, seat s
WHERE s.seat_num = 'A1' AND s.id_seat = ss.id_seat
But that query didn't work...How am I supposed to do? Please help me..thank you :)