Re: Query question
In article <5u6upt$blh@cssun.mathcs.emory.edu>,
Class Planning Yard <jps@nns.navy.mil> wrote:
>Does anyone know how to perform a
>query without knowing the table name?
>
>I know the attribute I looking for but do not
>know the table name.
>
I'm not quite sure what you mean. You can do something like this:
select tabname, colname
from systables, syscolumns
where systables.tabid = syscolumns.tabid
and colname = 'price_code'
to list all the tables that have a column named 'price_code', any use?
- Paul (his opinions only)