Posted by krusz10 on 09/20/07 15:47

I have a table (tableA) that lists a number of other tables on the
same database. I want to search each table listed in tableA for an
existence of an known entry and then display that entry and the table
its in
I can do it in other scripting languages but I'm new to SQL. Can you
help

I sort of want to do the following
Select * from everything_in(select tablename from tableA) where entry
= 'fred'

• Next in forum: CREATE Table permission
• Prev in forum: How Do I give EXECUTE Permissions on Stored Procedures?
• Thread view: Select statement help

[Reply to this message]