Hi all,
When i try inner join tables using VS.Net's Data Adapter Configuration
Wizard, it always return generate insert, update, delete statement failed
and it said
"The original query has a select list that has columns from multiple tables.
The statement cannot be generated automatically for this type of query. "

What should i do to in order to make it updatable/insertable/deletable?
Is there any tutorial telling how use Data Adapter in multi table
environment?

Thx in Advance!!!!

Hi Norton:
[quoted text, click to view]

Yes, using Joins is not a good choice here. instead, use two dataadapters
and pull over the data you need. You don't need to pull over everything in
both tables, just make sure that whatever you pull over in the where clause
for the child table and matching key values in the parent table.
[quoted text, click to view]

Yes, check this out http://www.knowdotnet.com/articles/datarelation.html and
let me know if you have any questions.

Cheers,

bill
[quoted text, click to view]