Generate DataSet rename tables

[ASP.Net programmer]

I have a few SQLDataAdapters which select a MAX() value from a few
different tables.

Here is a sample of the SQL statement:
SELECT MAX(startdate) AS startdate
FROM some_table1
WHERE (startdate <= GETDATE())

The problem I have is this: When I select a few of those SQLDataAdapters
to generate a DataSet from them the list of DataAdapters shows:

Table (daSomeTable1)
Table (daSomeTable2)

Other (normally selected) tables show up in the list like this:
AnotherTable (daAnotherTable)

If I add the daSomeTable* DataAdapters I get the following error:
"Cannot generate a dataset that contains multiple tables with the same
name (Table)."

Changing the SQL statement to the following code didn't work:
SELECT MAX(startdate) AS startdate
FROM some_table1 AS some_table1
WHERE (startdate <= GETDATE())

Does someone have the solution to this problem? I prefer to put all
those DataAdapters in one DataSet, if possible.

Thanks in advance

 

[ASP.Net programmer]

I found it. I could change the DataSet table name from the table mappings
collection.