access-query in a vb-datagrid ??

[kimage]

With help of a adodc i've selected the source of the database (an mdb-file)
so i make my grid and i select my datafield.
i want to show a query in my grid but i only see one table instead of the query which is a combination of 2tables.

how can i solve this?

thanx

 

[Pat Hartman]

Does the datagrid support Access queries or do you need to write one in VB?