Now that was fun and educational. :-)
I like the third approach, but theres an added problem to the whole thing.
This query is just a part of a bigger search.
The tables, job and color and other fields, which will also be searchable. I
am trying to automate the whole process, i mean, the user see
Sorry i replied from a different address. Heres the reply with some editing:
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing th
Hi,
I am trying to solve a problem that i have been stuck for a few days, i hope
you guys can shed some light on this.
I have two tables: enc and cils
JOB:
id_enc
num_of
name
CILS:
id_cil
num_of
color
each "JOB" is composed of severals "CILS" (i know i should link tables using
id_enc, but for
