Posted by calan on 10/01/49 11:27

<snip>

So back to the original question, is there an SQL example of this? I'm not
having any luck finding anything on using a subquery in a FROM clause that
returns a list of table names.

I thought something simple like this would work (This assumes that all
tables listed in "MyTables" will have a field called "Configured".):

SELECT t2.TableName, t1.Configured
FROM (SELECT TableName FROM MyTables AS t2) t1

But it doesn't....

• Next in forum: Re: Any way to find out which SP is updating data in a specific table?
• Prev in forum: Re: Is there a way to find growth in log (ldf) and database(mdf) ?
• Thread view: Re: searching a list of tables, derived from another table

[Reply to this message]