How to Query a List of Tables to Find Common Fields

[swhitfield]

Greetings & Salutations....

I search for the ability to query all Tables in our version of SQLBase 7.6.1 in order to locate those Tables with 2 Field names: Inventory Transaction & Trace ID

Is there a way to query such via SQLTalk?

Thank you in advance for your assistance.

 

[swhitfield]

Survey says????

I try to post the answers as I come about them...my thanks to those who may have viewed to help...but unable to do so.

Answer:
select * from syscolumns where name like 'TRANSACTION%' or name like 'TRACE%' order by name ASC;