|Subject||Re: [ib-support] How to do a union?|
|Author||Svein Erling Tysvær|
>I used Helen's previous suggestion created a view and then did a joinWhy use a view for this? Simply do a
>on the view and the lookup table. It solves my problem.
select tablename, weight
from replication_order ro
where exists (select 1 from replication_log rl where rl.tablename =
order by 2
This should get you what you appear to want pretty quickly.