Cered
asked on
combining tables in access 2016
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PatHartman
If you think that every row in table A has a match in table B, then something is either wrong with the join or your data is not what you think it is. For the join to produce 842 rows, AppName must be UNIQUE so that there are 842 unique AppName values and each table must have one and only one instance of each.
Pat,
There could be a WHERE clause in the OP's query as well, he/she didn't say, or give us the SQL he is running to get said results.
There could be a WHERE clause in the OP's query as well, he/she didn't say, or give us the SQL he is running to get said results.
True, but it didn't sound like it from the description.