multiple table search

[Ruslan Zasukhin]

On 3/30/05 10:30 PM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

Aha! Ivan suggests the same.

Gregory, you really should re-think your structure.


> In this case UNION seems to be a best solution. But if you have any ability
> you should consider some normalizing for the database to have such product
> numbers > - all together - in the separate "refference" table. Other tables
> will point to records in this one using the links. Valentina has 3 link types
> - not only key-based (RDB) one. In this case you get the ability to use
> table-joins and your query becomes much more clear - just "give me all linked
> to this product number records".
> 
> 
> 
> You can find more details in the docs.
> 
-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]