This may seem simple, but I'm having difficulty figuring out how to fill my dataset when my query includes more than one table.

For example, if I had a query that was "SELECT USER\_ID, USER\_NAME, CREDENTIALS FROM USERS, CREDENTIALS WHERE USER\_ID = CRED\_ID" and then try to use the DataAdapter.Fill method it throws and error saying it's not a single group function. 

My DataAdapter is = da  

My DataSet is = ds

What I'm trying is:

```
da.Fill(ds, "USERS;CREDENTIALS"); 

```

or 

```
da.Fill(ds, "USERS, CREDENTIALS");

```

How would I go about doing this correctly?
I just need to run a query that selects from 2 tables based on a matching ID, but I'd like it in a single Dataset so I can go through the results 1 row & column at a time.

Any help is GREATLY appreciated!