Hello, My problem is when I have a situation like this:
I have many events which I categorize them. Each event has A Category, how can I make a single query with each category accompanied with 2 events?
ex:
Category
cat_1
cat_2
cat_3
Events
Ev_1, cat_1
Ev_2, cat_1
Ev_3, cat_1
Ev_4, cat_1
Ev_5, cat_2
Ev_6, cat_2
Ev_7, cat_2
Ev_8, cat_2
Ev_9, cat_3
Ev_10, cat_3
Ev_11, cat_3
Ev_12, cat_3

My query result has to be like this
cat_1, ev_1
cat_1, ev_2
cat_2, ev_5
cat_2, ev_6
cat_3, ev_9
cat_3, ev_10

Thanks
Tata