getting data from multiple tables

[tracy6001]

hi,
i wanted to retrieve three fields from two tables according to the two dates ..
between the two dates how i will retrieve the data ...
do i have to add 2 dataadapters?
2data sources?
thanks

[Curtis Rutland]

You could probably do a JOIN in your SQL statement.

[semomaniz]

As mentioned by isertAlias use Joins for retrieving data from multiple tables its lot easier and faster

example :

Select Data1, Data2, Data3 from Table1 Join Table2 on Table2.id = Table1.id

here id is a primary key on table 1 and foreign key on table 2

I hope you get the idea.