There are a few ideas for you. Honestly, if you are not very comfortable with databases and programming, or if you are a novice, I would go with option 2. Option 3 is for the experienced, and option 1 is for beginners.

HTH!

luigicannavaro

09-18-2007, 03:27 PM

Thank you.

I am tired of "theory" I want to see "practice" and "real code" not "infinitesimal calcul". The solution 1 it is trivial. Certainly between solution 2 and 3 must have a great difference in speed and storage. I think I have a similar code for doing the option 3 in my shares!

Best for you.

Luigi

luigicannavaro

10-18-2007, 04:25 PM

Daemonspyre,

I have decided reopen this thread because someone did a question - in true as ASK - and I am in doubt.

How do you would did for searching the values of SOURCE TABLE (table3) in keywords (table2) for finding at once, for example: "Arsenal Liverpool" if in table2 these values are in different records? good question?