>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?
You can simply use AND:
SELECT Invoice.Numero
FROM Invoice
WHERE Invoice.NoClient = Invoice.NoClient2 AND
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)
AND Invoice.NoClient2 IN (79)
Update: Not sure I got you right. Discard.