Hello every one,
I have encountered a problem while working .I have a sample table with the following data
| TID | Date | Item |
| T100 | 8/1/2010 | Laptop |
| T100 | 8/1/2010 | Desktop |
| T101 | 8/1/2010 | Laptop |
| T102 | 8/1/2010 | Desktop |
| T103 | 8/2/2010 | Laptop |
| T103 | 8/2/2010 | Desktop |
| T104 | 8/2/2010 | Laptop |
need the data when a person bought laptop & desktop on the sameday.I used a condition in where clause but its not working,it is returning no rows.Can any one please help me to resolve this issue ?
condition in where clause :
table.date in date() to date() and table.item = "laptop" and table.item = "Desktop"