Forum Discussion
Basic query question - query not returning results from 2 tables
I have attached a picture of the query I'm attempting to run. Now, it's been a few years since I've used Access. But, I don't remember it being this difficult! I'm probably doing something really ...
SELECT [Care Givers].[First Name], [Care Givers].[Last Name], [Classes per pathway].ClassFROM [Care Givers] INNER JOIN [Classes per pathway] ON [Care Givers].Pathway = [Classes per pathway].Pathway;
For one thing, there is a missing space in front of the FROM
Could you have defined different data type for the Pathway fields?
Take a look at the attached and compare it with your version.
On a side note, you really should avoid spaces and special characters in field and object names. You may like to browse: https://www.devhut.net/2017/04/20/access-best-practices-and-troubleshooting-steps/