Simple query returns no results

[jhuvba]

I have a simple query to join information from two tables based on a matching primary key:

SELECT Visits.Date, Results.IDFROM Visits INNER JOIN Results ON Visits.Id=Results.ID;

There are about 250,000 records in the visits table, and 8000 in the results table. I have double checked in Excel and all IDs from Results are found in Visits. However, this query returns no results. A Left Join will only return Visits.Date with no Results.ID, a Right Join will only return Results.ID with no Visit.Date. Any idea what is going on? I'm able to run join queries from Visits with other tables in my DB using the same ID key or other fields. Any query I run that includes the results table returns no records, however.

[pbaldy]

As far as the database engine is concerned, there are no records where those fields match. Can you attach the db here, or at least a picture of the two tables showing those fields?

[jhuvba]

Unfortunately given the data in the workbook, I'm not sure I can upload a sample or photo without changing the keys to anonymize it. If you have any suggestions on how to upload it or how to fix this I'd appreciate it!

[pbaldy]

Are the data types the same? Can you copy/paste values from those fields that should match? Could there be spaces in one and not the other?

[jhuvba]

Figured it out. My input mask was hiding the problem. For some reason the Results.ID field was stored without a decimal point, but had one added from the input mask, while the Visits.ID had a decimal point in the actual string.

[pbaldy]

Glad you got it sorted.