Posted by shawn on 10/05/53 11:31

Hi I have a situation where the user will choose a subset of a list of items
and display by submitting request. For example I have apple, orange and
pear. A user may select apple and pear, or orange and pear or all etc.

How to I contruct the WHERE clause?

SELECT fruit_name, price FROM fruit_table WHERE fruit_name = .....

Can you help?

Thanks!

Shawn

[Back to original message]