I have an issue regarding the Exists function with the code below:
SELECT l.street, l.Number, l.Direction, l.suffix, l.Unit, l.LienNumber, l.LienType, l.DateField, l.Amount FROM Localities AS l WHERE (((Not Exists (SELECT * FROM vw_BRT WHERE street = l.street AND streetNum = l.Number))));
For whatever reason the addresses on E street and anything from 66TH Avenue through 80th Avenue. Note that these are not in one section of the data as the index is a BRT number which is based on many qualities of where the property is located in the city so for instance you could have 10 66th Avenue have the BRT number 101010101 and 8600 66th Avenue have the BRT 886890300.
Is there any reason besides corruption to why these will not come up as out of 92k records in the localities table these are the ONLY records that have any issues.
Please note that I also ran the same query in Access with the EXACT same results.
Any help would be much appreciated.