hello, Example : i hv a table containg date, flower, perfume,codeno,regno etc
There are some row which have only flower entries for a day. there are some rows which have only perfume entries for a day. some rows have both florwer and perfume entries for a day..ie same day contains both entries. same flower names may repeat but on diff dates or on diff regno. similarly for perfume. but table has no duplicate entries. Query : what i want is 1) To retrieve those records for which there is both entries for flower and perfume on same date 2) To retriev records for perfume entries which have flower entries for the same date , same regno and same codeno. 3) To retrieve records which doesnt hv a flower entry for the same date as that of perfume ==================================================== N. Kavithashree =================================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]