protected void Page_Load(object sender, EventArgs e) { // Generates tables DatabaseManager dbManager = new DatabaseManager(); dbManager.GenerateTable("SELECT * FROM tblBird", tblBird); dbManager.GenerateTable("SELECT * FROM tblMember", tblMember); dbManager.GenerateTable("SELECT * FROM tblBirdMember", tblBirdMember); // Required query String testQuery = "SELECT tblBird.englishName AS English, tblBird.maoriName AS Maori, tblMember.first AS Firstname, tblMember.last AS Lastname FROM tblBird INNER JOIN tblBirdMember ON tblBird.birdID = tblBirdMember.birdID INNER JOIN tblMember ON tblBirdMember.memberID = tblMember.memberID"; dbManager.GenerateTable(testQuery, tblTestQuery); }