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 the purpose its better this way - converting from thrashy ooold database - but "num_of" on "JOB" is unique, so no worries. what i need to do is find records on "JOB" that have "cyan" and "magenta" for color in its associated "CILS" records, for example. if i make a join with both tables, i can do a where for just one color, which finds all "JOB"s that have cyan, but i dont know how to make a query that checks if two colors are on the same "id_enc". Would really appreciate some pointers on how to build such a query. Thanks.
