How do I use SQL to SELECT multiple tables from an access db for a single dataset in C#?

See more:

C#

SQL

Visual-Studio

Hi everyone,
I'm moving on from VB.Net to Visual Studio C# and recoding a previous project from VB.Net to C#. I'm extremely new to C# and only ever used single SELECT SQL Queries in my VB.Net code. I'm trying to make some changes to the way I implement my design and have read that it should be possible to use SQL to SELECT multiple tables from an Access db into a single dataset; however, I'm getting a 'characters found after end of SQL statement' error.

What I have tried:

Looking at examples online I thought I was using the correct SQL syntax, but clearly not! I've probably made several errors given my lack of familiarity with C# and limited use of SQL. This is the code I'm using:

public partial class MainWindow : Window
    {
        private readonly string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:/Users/Me/Documents/My Games/Race/Race.accdb";
        private OleDbConnection accessConnection = null;
        private OleDbDataAdapter daShipData;
        private OleDbCommandBuilder dbCommandBuilder;
        public DataSet dsShips = new DataSet();

        private readonly string shipSelectionSQL = "SELECT * FROM Race2Ships ORDER BY ID; SELECT * FROM Race1Ships ORDER BY ID;";
        
        public MainWindow()
        {
            InitializeComponent();
            LoadData();
        }
       private void LoadData ()
        {
            try
            {
                accessConnection = new OleDbConnection(connectionString);
                accessConnection.Open();
                MessageBox.Show("Connection Opened");
                OleDbDataAdapter daShipData = new OleDbDataAdapter(shipSelectionSQL , connectionString );
                daShipData.Fill(dsShips, "ShipData");
                accessConnection.Close();
                MessageBox.Show("Connection Closed");
            }
            catch (Exception ex ){ MessageBox.Show(ex.Message); }
        }

    }