I have a database that is SQL and I am currently connected to the table players however I want to use some fields from teams table how would I do this?

I have a database that is SQL and I am currently connected to the table players however I want to use some fields from teams table how would I do this?
Just add the other table as a datasource in your app and then perform functions to gather what you need from the other.
If there is some connection between records in one table to the other, then utilize the Lookup function against the other table with the required criteria from the first table.
I hope this is helpful for you.