I am looking for a resource that cleary explains the capabilities of .net and access queries.<BR><BR>so far, I have been successful at deal with connecting to a single table.<BR><BR>now I need to join a couple of tables to display reference information. in my head, the easiest way to do this is to create the query in access. make certain I get the data I need, then either copy and paste the sql into the .net pages, or somehow reference the query I created.<BR><BR>I know this is a high level example. I'm trying to get my head around this as I try to move the project forward. any reference material or insight will be greatly appreciated.