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
el********@hotmail.com

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

[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....microsoft.com

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 7 Apr 2005 12:00:59 -0600, "Shawn H. Mesiatowsky"
<smesiatowsky@_no_spam_perfectfit-ind.com> wrote:

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