I have two tables;
Vehicle1 Vehicle2 Vehicle3 Vehicle4 Vehicle5
(I’m just give you information which you might need…)
In Vehicle1,Vehicle2… i store ID of vehicles.Now,i want to delete all vehicles which are not on any slot(Vehicle1,Vehice2…) from table users.
So.I need to selet all ID from user table
SELECT Vehicle1,Vehicle2,Vehicle3,Vehicle4,Vehicle5 FROM users
And now delete all ID from vehicle which are not on any slot.I hope you can understand me,sorry for my English.