need help with a query, please

[Quoted] [Quoted] I have some 250 tables that have the same structure and I need to search [Quoted] each one for a specific entry. here is the query that I have to check [Quoted] just one table:

select orderid, tracenumber, username
from sp236_transaction
[Quoted] where orderid = '963262260741'

the sp236 is the only thing that changes in the table name and this query. Is there a way I can loop through all 250 tables?

TIA Joe Received on Tue Jul 18 2000 - 00:00:00 CEST