hi. my thread title seems strange but its really about comparing unlike values as an output.
I want all values that are not LIKE the other values. To make things clearer. Here's my query:
SELECT Records.[Officer ID], Records.[Plate Number], Records.[Violation Commited], Violations.[Violation Code], Records.[Street Name], Records.[City of Apprehension], Records.[Vehicle Category], Records.[Vehicle Type], Records.[Vehicle Brand], Records.[Date/Time Apprehended] FROM Records,Violations,DriverInfo WHERE Records.[Plate Number] NOT LIKE DriverInfo.[Plate Number] and Records.[Violation Commited] like Violations.Violations
What I want to do in here is select all columns that has the column name value,which is not equivalent to the other column from another table. So its like saying, "From all eggs that came from Hens , select those who are not eggs of Hen # 1."
When I tried the NOT LIKE query. it still showed the ones that are LIKE and worse, it redundantly displayed its data. Any suggestions?