Select between 2 tables

Question

Select between 2 tables

Navigation

#1 by (2 votes)

2

Based on the tables below and passing the 'start date' and 'dataFim', would it be possible with only one Select select from the Vehicle Table only vehicles that are not in the Reserve Table? I'm studying Inner Join, but I have no idea if this is possible.

Tabela Veiculo
--------------
idVeiculo
nomeVeiculo


Tabela Reserva
--------------
idVeiculo
dataInicio
dataFim

mysql

asked by anonymous 17.05.2016 / 05:33

1 answer

Join php arrays by allocating combined values between the two How to pass data searched by a view back to the view itself

score 2 · Accepted Answer

The first thing to do is to create a key for the relationship between the two tables, after that, it would look like this:

SELECT v.nomeVeiculo FROM VEICULO v
INNER JOIN RESERVA r on v.id not in r.veiculo_id;