<div>
A Cartesian Product should produce the result you want.<br />
<br />
Create a new query. &nbsp;<br />
Add all the tables to it.<br />
Select the player from each table.
</div>


A Cartesian Product should produce the result you want.

Create a new query.  
Add all the tables to it.
Select the player from each table.

<div>
Problem is, you are going to have players who play more than one position,so you are going to have to exclude all of those combinations as well.
</div>


Problem is, you are going to have players who play more than one position,so you are going to have to exclude all of those combinations as well.

<div>
<div class="content wysiwyg-content">
Let's say I have 9 Tables: Catchers, Pitchers, Shortstops, First baseman, Second baseman, Third baseman, Left fielders, Right fielders, Centre fielders<br />
<br />
Let's say each of these tables has 5 different 'Players' in it.<br />
<br />
Now I want to get all possible team combinations (comprised of one of each position) into another table called 'Teams'<br />
<br />
From my understanding of permutations there are 1,953,125 possible teams (5^9).<br />
<br />
Any idea how could I create this 'Teams' table in SQL (I'm using MS Access by the way), there should be a column for each position?
</div>
</div>


Let's say I have 9 Tables: Catchers, Pitchers, Shortstops, First baseman, Second baseman, Third baseman, Left fielders, Right fielders, Centre fielders

Let's say each of these tables has 5 different 'Players' in it.

Now I want to get all possible team combinations (comprised of one of each position) into another table called 'Teams'

From my understanding of permutations there are 1,953,125 possible teams (5^9).

Any idea how could I create this 'Teams' table in SQL (I'm using MS Access by the way), there should be a column for each position?

Get all permutations of baseball players on a Team in SQL

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.