>I have a select such as:
>
>
>SELECT Invoice.Numero
> FROM Invoice
> WHERE Invoice.NoClient IN (5,44,52,54,55,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72,73,69,74,75,76,77,78,80)
>
>
>Then, we could have another one such as:
>
>
>SELECT Invoice.Numero
> FROM Invoice
> WHERE Invoice.NoClient2 IN (79)
>
>
>I need to combine both selects into one which would return only the records where Invoice.NoClient and Invoice.NoClient2 match in both.
>
>For example, in the example above, none would be returned.
>
>However, if I would have this:
>
>
>SELECT Invoice.Numero
> FROM Invoice
> WHERE Invoice.NoClient IN (5,44,52,54,55,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72,73,69,74,75,76,77,78,80)
>
>
>Then, we could have another one such as:
>
>
>SELECT Invoice.Numero
> FROM Invoice
> WHERE Invoice.NoClient2 IN (5,44,79)
>
>
>Then, as 5 and 44 match both, this means I would have some results.
>
>What would be the simplest way to achieve that?
Take a look at
EXCEPT and INTERSECT
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges