Re: Help for a query with MYSQL 3.23.58

First, let's just consider finding the id_products in the products_value table which match the given list of id_values. Here are 2 ways to do accomplish that: 1) Join the table to itself once for each member of the list, requiring the id_value for each copy to match one of the values in your l

RE: Help for a query with MYSQL 3.23.58

Michele on Friday, October 08, 2004 4:57 PM said: > Have I well understood the meaning of your answer ? It was meant as a joke and not a serious response to your question. I apologize for the confusion. Chris. -- MySQL General Mailing List For list archives: htt

Re: Help for a query with MYSQL 3.23.58

> 2) I'm looking for id_product that can contemporaneously satisfy more > than an id_value (NOT ONLY ONE!!) contemporaneously? that's got be one of the best made up wor... wait what? you mean it's a real word? http://dictionary.reference.com/search?q=contemporaneously I'm not sure to understand

RE: Help for a query with MYSQL 3.23.58

Michele on Friday, October 08, 2004 3:23 PM said: > 2) I'm looking for id_product that can contemporaneously satisfy more > than an id_value (NOT ONLY ONE!!) contemporaneously? that's got be one of the best made up wor... wait what? you mean it's a real word? http:

Help for a query with MYSQL 3.23.58

Could you help me with a query? 1) I know some values of id_value in the table below : PRODUCTS_VALUE. 2) I'm looking for id_product that can contemporaneously satisfy more than an id_value (NOT ONLY ONE!!) For example I'm looking for all id_product that can contemporaneously satisfy (id_value=