I have two tables in mysql
I have a column in both tables called regno
I want a query that will display vehicle regno that is not in contributions
What I tried:
SELECT vehicles.regno FROM vehicles,contributions
WHERE vehicles.regno<>contributions.regno
ORDER BY vehicles.regno;
Please help. thanks in advance.
SELECT regno FROM vehicles
WHERE regno NOT IN (SELECT regno FROM contributions);
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments