I have 2 tables in access with the sme number of rows, but not the smae number of columns. In table A, i have a column labeled App.Name and in the table B i have a column named App. Name. These two columns have the same data in both. In table B, i have a column labled rating. Not every app has a rating. is it possible to run a query to to pull all of the app names from table A, and put that information into a table, and then pull the BIA ratings from table b and put that into the new table for the correct app?
I have tried to put together a couple of queries but i only have been able to get a new table of the apps with a BIA raiting. Table A has 842 rows, table b has 842 rows and the new table is only ending up with 153 rows.