WHERE IN with AND is not working. What's wrong with this?

[won_lek]

I have attached a picture with this post. Anybody has idea why SQL Query statement is not working?

WHERE IN ((xxxxxx = 10 AND yyyyyy= 20),(xxxxx=3 AND yyyyy=5))

Why the above SQL statement can't correctly return what I want?



(Please refer to the picture that I have uploaded?)

Thanks.

[NoellaG]

I think in the example you need a statement like:

select MachineID, MachinePart, MachineColour from Table1 where (MachineColour = "Yellow" and Machinepart = "Cover) or (Machinecolour = "Yellow" and machinePart = "Shaft")

[pbaldy]

Or, using IN() properly:

...where MachineColour = "Yellow" and Machinepart IN("Cover", "Shaft")

[won_lek]

I can't changed to what you have suggested me.

This is because I don't know how many of the combination will appear. I will use the listbox in the future.

And actually it is not only Yellow colour as mentioned in the example.
There will be various combination.

Sorry about that, and really thanks and hope someone can help me.

[won_lek]

Anybody has any idea on this? please?

[NoellaG]

Hi,

of course you don't have to copy the statements, they're just examples of the correct syntaxis you can use. You can have indefinite combinations, just respect the correct syntax and the query will work.

succes
NG

[pbaldy]

I love moving targets. Here's one way to use a multiselect listbox:

http://www.baldyweb.com/multiselect.htm