I used the formula:
SELECT * FROM Census INNER JOIN Crime ON Census.County = Crime.County
I changed Place in the Crime sheet to be called “County” and tried cleaning the data so that both had columns on the far left side with counties in them, but while the formula gave me a table with correctly joined columns, it does not display any data.
I’m not sure what the issue is. I tried many things to correct the data and clean it but nothing seemed to work.
Yes, your SQL said the query was good (“not an error”) so there is probably a mismatch in your data.
My issue was the data in columns I was trying to match were not trimmed properly. =trim and then copy, paste special – values is what I did to fix it.
Look at the data and homework answer I posted:
https://wordpressua.uark.edu/datareporting/final-project-april-18-may-4/