I have this site for my softball league (here, for reference). Currently on the standings page it takes the wins/losses/win%/runs scored/runs against out of ...

Using SELECT. A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the statement’s FROM clause to combine results from multiple tables.