Imam tabelu tActivity koja ima sledeca polja:
activityID, description, componentID, taskID, itd...
Recimo da je tabela popunjena na ovaj nacin:
+------------+-------------+-------------+--------+
| activityID | description | componentID | taskID |
+------------+-------------+-------------+--------+
| 5 | a1 | 1 | 1 |
| 6 | a2 | 2 | 1 |
| 7 | a3 | 1 | 2 |
| 8 | a4 | 1 | 1 |
+------------+-------------+-------------+--------+
E sad, ja zelim da mi se ispise ova tabela grupisana po componentID polju, a kasnije i po taskID-iju, tj u obliku
| description | componentID | taskID |
| a1| 1 | 1 |
| a4| 1 | 1 |
| a3| 1 | 2 |
| a2| 2 | 1 |
Kada mu zadam query:
Code:
select description, componentID, taskID from tActivity where (componentID=1 or componentID=2) and (taskID=1 or taskID=2)
group by taskID, componentID;
select description, componentID, taskID from tActivity where (componentID=1 or componentID=2) and (taskID=1 or taskID=2)
group by taskID, componentID;
ispisuje mi:
+-------------+-------------+--------+
| description | componentID | taskID |
+-------------+-------------+--------+
| a1| 1 | 1 |
| a2| 2 | 1 |
| a3| 1 | 2 |
+-------------+-------------+--------+
dakle, bez a4 activity-ja
Znali neko u cemu je problem? Hvala unapred! Ja pretpostavljam da je to mozda zbog toga sto vec postoji par (componentID, taskID) = (1,1) u a1 activity-ju, pa zato nece da ispise a4. Medjutim, ovo je potpuno realna situacija, a bice mi potrebno grupisanje rezultata na ovaj nacin.
Pozdrav i jos jednom hvala unapred,
SM
To me boxing is like a ballet, except
there is no choreography, no dancing and the dancers hit each other...
there is no choreography, no dancing and the dancers hit each other...