May 16th, 2000, 04:19 AM
|
|
Junior Member
|
|
Join Date: Apr 2000
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
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
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
