|Subject||RE: [ib-support] How to do a union?|
> >I used Helen's previous suggestion created a view and then did a join
> That is very almost what I want I will try to explain it again.
> Replication Log
> I would want to do a distinct selection so I get the following result
> Then I would want to itterate through this list and do the
> replication table
> by table.
> First problem some tables need to be replicated before others so the list
> needs to be
> sorted in a specific way. I cant sort it alphabetically so I need
> to lookup
> weight for the table to know how to sort it. Here is typically
> what I would
> like to end up with after I have sorted it to weigth.
> TableName Weight
> MTRL_GLASSPRODUCTS 4
> MSFRAMES 8
> MSMOUNTS 9
> POS_MISC_STOCK 15
> POS_BILLOFMATERIAL 18
> I hope this helps to explain better.
on the view and the lookup table. It solves my problem.