how can I find all member who are not in another table

Question

SELECT a.id, 
       a.driver_name, 
       a.route 
FROM assigns a 
INNER JOIN vehicles v ON a.id = v.assign_id NOT IN (vehicles)

Answer 1

I don't know you tables structures but something like this.

SELECT a.id, 
       a.driver_name, 
       a.route 
FROM assigns a 
LEFT JOIN vehicles v ON (a.id = v.assign_id)
WHERE v.assign_id IS NULL