SQL Innerjoins and data views

[Shawn H. Mesiatowsky]

Is there a way to use more then 1 table in a dataview? suppose you had 2
tables with an innerjoin in the sql statement, how do you retrieve this info
into a data table? or do you need to create 2 data tables and add a relation
to them? How about using Views in SQL server itself. Can I just create a
view in SQL Server (with the inner join in the view), then would this act as
a single table? Thanks

 

[Elton Wang]

Hi Shawn,

If you mean to do join query to multi-DataTables in a
DataSet, I'm suppose you can't do it. You need directly
join query multi-tables from database to get single result
set.

HTH

Elton Wang
(e-mail address removed)

 

[Scott Allen]

Hi Shawn:

There is no built in way, as Elton mentioned. MS does provide some
code to help out:

http://www.google.com/search?hl=en&q=join+helper+c#+site:support.microsoft.com