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.
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.