Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Selecting a Table based on another Table's Field

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-21 : 12:07:20
Lisa writes "I have a table called "Collections" and it has a field called "ResultTableName" and "CollectionName".

Then I have 5 Tables that have the same name as what is in the field "ResultTableName"

Based on what the user selects in the CollectionName Field, I need to then like to the Table that matches data the ResultTableName field to gather my data.

Is their anyway to do this?

Lisa"
   

- Advertisement -