figured it out. had to create something called a view and then create a collection from the new view table thats created…but then there was an issue with ids because both tables had an id column. So I had to call each one of the columns separately and not the id from one of the tables.
It seems odd to me that there is no way to say “all but this column”, which would have been easier, but this is what it looked like for anyone else who might get this issue.
