I am doing a simple join query in Access. I want the resulting
recordset to have an alias name that I can refer to. Can anyone
please help me with the Access SQL syntax because I can't find
it in any books.

My query is:
  select employee.id, employee.name, employee.address,
  paygrades.grade, paygrades.insurancenumber from employees
  join paygrades on employee.id = paygrade.id
  where employee.department = 'IT'

How can I set the resulting record set to be called 'myRecords'

Can I then use a VB.Net datagrid to bind to the result set eg.

  myGrid.SetDataBindings(myDataset,"myrecords")

If I do the above query I can only bind to a single table -
ie I either bind to the employees or to the paygrades. I need
to get all fields into my bound data.

Any ideas?

What are you trying to do.
Binding a query to two tables? please explain further



Sal