It's Sunday and my brain is fried -- seems like this should be simple.
I have two tables.
tblA contains two columns tblA.id, tblA.value
tblB contains two columns tablB.id, tblB.value
.value is a text field
I want to return values from tblA.value where tblA.value is not equal to tblB.value.
So, I tried (in MS Access):
I'm trying this as I type:
FROM tblA, tblB
WHERE lcase(tblA.value) <> lcase(tblB.value)
The first query did not return what I expected (more rows than are in tblA). The second query is taking forever to run. FWIW: tblA has about 10,000 records and tblB has about 70,000.
WHERE lcase(tblA.value) NOT IN
(select lcase(tblB.value) from tblB)
Any help would be greatly appreciated!