I have a car rental project, when renting an available car from database table CAR with
car ID as primary key, I insert data into table
reservation ID as primary key and
car ID as foreign key from
However, I don't want the car I just rented out to appear as an "available car" to rent. What query should I write in order to hide it?
Select cars.* from cars, reservation where ?