I have loaded a grid with data from a single table, and would like to know what adaptations are required to use a multi-table join.

What I have is something like this:

String query = "select * from Student order by LastName";
da = new OleDbDataAdapter(query, Cn);
ds = new DataSet();
da.Fill(ds, "Student");
this.dataGrid.DataSource = ds;
this.dataGrid.DataMember = "Student";

Data is stored in Access. I don't think I would have trouble with the JOIN (unless Access syntax is significantly different from Visual FoxPro), but:

What should I replace for "Student" in lines 4 and 6, if the query spans 2 or more tables?

TIA,

Hilmar.