zeeshanhashmi — 2010-06-02T08:22:20-04:00 — #1
I have a table with a few columns. Now, two columns are this :
Now what I want is all the DISTINCT players id no matter winner or loser.
so that if the table has following data:
i want a list like:
Please guide me how this can be achieved, thanks !
zeeshanhashmi — 2010-06-02T09:04:57-04:00 — #2
well, can you please give me an example query ?
guelphdad — 2010-06-02T08:24:24-04:00 — #3
do a UNION on the table, once for winners, once for losers.
zeeshanhashmi — 2010-06-02T10:14:32-04:00 — #4
Wow thanks a lot, i got it.
swampboogie — 2010-06-02T10:13:54-04:00 — #5
select winner_id player_ids