SQLTeam.com | Weblogs | Forums

Query a dataset that includes a table that is not in the database using Visual Basic

The topic doesn't really describe what I need. I have a SQL server database that has many tables. In one particular table there is a column that has xml that provides the structure for a related table and another table that has column with xml that provides the data for the related table. I can easily create the table from XML, but I don't know how to use a connection, etc. to query the database tables including the related table. The database is large so I don't want to create datasets for each of the tables in the database and then merge them. BTW, I am using vb.